Make your accounting spreadsheet fit your nonprofit by editing your Automatic Accounting workbook.
Okay...let’s do the easy revenue and expense account modification first
Deleting Revenue and Expense Accounts (GL-Jan)
Tip: It's easier to hide the accounts you do not need than to delete them...
(Note: Used the 1 fund accounting workbook for the following example...so row numbers may be different in multi-fund workbook)
Simply highlight all the "accounts" (rows) you do not need; right click; go down to hide; and click. For example, say you only need 2 income accounts for right now. Highlight rows 26-88…right click….move down to HIDE and left click. You’ll notice your row headings now read ...24, 25, 89, 90…. The extra income accounts are there hidden and can be “unhide” when you need another income account.
You will need to “hide” those extra income accounts on every worksheet in the workbook.
IMPORTANT-Hide the same accounts through the entire workbook.
For example: if you are hiding the last 4 expense accounts then make sure you hide the last 4 expense accounts throughout the entire workbook.
Church Accounting Package
A set of 4 ebooks that covers the following topics...
In the first worksheet(GL-Jan), select the rows to need to delete with the desired amount of line accounts. (Hint: Take the bottom line accounts if possible so you will not have to reset the balance column formulas again.)
For an example, we are going to take out the bottom 2 expense accounts.
You will do as above (make sure you select bottom income account(s))except after step 4 you will need to reset your balance column:
In the Jan monthly report, select all the rows with the
If it took out the last line under expense, you will need to put the border back in, go to the home tab if not already there, in the font group, click on the borders arrow and go down to double border...or whatever border you want), click where you want them.
Repeat steps for the annual report.
Adding more line accounts isn't too difficult either...just takes some time.
The Spreadsheet Package includes a workbook for tracking contributions, an automatic accounting workbook for tracking up to 5 funds,10 income accounts and 40 expense accounts and several more accounting workbooks. It also includes a Word document with 3 customizable contribution statements.Click here for more information or purchase now for $19.95
Let’s practice by adding another expense account (you can always delete it or use your back arrow to get rid of it later).
Important: Make sure you are in the GL-Jan worksheet!
Now to fix the balance column:
When you are finished adding accounts, you will need to add them to the Total debits (expenses) cell at the bottom:
Okay...now you know how to add more line accounts, and you are thinking...that wasn't too bad...hold that thought while we go to the monthly report and add that expense account we just added into the general ledger.
Look at the bottom tabs...click on the tab named “Jan”.
That’s it for the monthly report! You will need to repeat the steps listed above for each line account you add.
That’s it! Don’t forget to save a copy of all your hard work and keep in a secure location
If you want to DIY your payroll, I highly recommend you look at using Gusto! It is very user friendly and their support is awesome! Plus they know how to set up and maintain payrolls for churches and nonprofit organizations.
Note: I am a "partner" of Gusto, but as I have told you before ... I never recommend anything that we or our clients have not tried and love =)