Hello,
I'm a beginning accountant and I've been given as my first project to construct a spreadsheet that outlines our company's General Ledger Accounts by department and division. To be more specific, our company has various general ledger accounts (e.g. expenses, revenues, etc...)dedicated to each department. Our goal is to have people use this sheet as a reference and thus have transactions properly recorded in the appropriate department for budgeting purposes.
For Example: Our company has four divisions. Each division has various departments. Our departments consist of Customer service, Sales, M.I.S., IT Group, Human resources, Engineering, R&D, Finance & Accounting, etc... Each department has general ledger accounts that look like this:
e.g. 4250-320--2. The first number represents whether it is an expense, revenue, prepaid, asset, etc... The second number represents the department in which the first number goes into. The last number represents the divion in which the department is located in.
My goal is to put all this information into a spreadsheet table (for each division) that is concise, simple to read, easily searched, and with a creative touch. We've been having problems with people putting expenses (transactions) into the wrong department or division. My spreadsheat is to correct this problem, so that people can easily use the sheet as a reference for transactions.
Can anyone help me on a design for my spreadsheet? Does anyone have something similar that I can use? Can you please post a design.
Thanks for all your help,
Goodfella
I'm a beginning accountant and I've been given as my first project to construct a spreadsheet that outlines our company's General Ledger Accounts by department and division. To be more specific, our company has various general ledger accounts (e.g. expenses, revenues, etc...)dedicated to each department. Our goal is to have people use this sheet as a reference and thus have transactions properly recorded in the appropriate department for budgeting purposes.
For Example: Our company has four divisions. Each division has various departments. Our departments consist of Customer service, Sales, M.I.S., IT Group, Human resources, Engineering, R&D, Finance & Accounting, etc... Each department has general ledger accounts that look like this:
e.g. 4250-320--2. The first number represents whether it is an expense, revenue, prepaid, asset, etc... The second number represents the department in which the first number goes into. The last number represents the divion in which the department is located in.
My goal is to put all this information into a spreadsheet table (for each division) that is concise, simple to read, easily searched, and with a creative touch. We've been having problems with people putting expenses (transactions) into the wrong department or division. My spreadsheat is to correct this problem, so that people can easily use the sheet as a reference for transactions.
Can anyone help me on a design for my spreadsheet? Does anyone have something similar that I can use? Can you please post a design.
Thanks for all your help,
Goodfella