Download

This tool enables you to maintain a detailed ledger of donations received by your organisation, and then generate a summary to enter into your accounts software using different Budgets and Accounts Here's a brief description of the different sheets Budgets and Accounts ============== Enter the names of the budgets you want to use and the names of your income accounts. These will then appear in drop down lists on each donation sheet you create and also on the reports. If you use the same Budget and Account names that are in your accounting software (MYOB, Reckon etc) it will make it easier to enter a summary of each sheet into your accounts program. Donation Sheets ========== Use the drop down box on the front page to access the individual donation sheets. Each donation sheet lets you record the name of the donor, the donation method (including the last 4 numbers of their credit card if applicable), the amount donated, and provides columns to allocate each donation to a budget and an income account. Create your own sheets by clicking Create New Sheet (on the front page). A common method is to name each new sheet with the date on which you process a batch of donations, and then the total of that sheet can be entered as a single entry with the same date in your accounts software by using the totals on the Summary per Sheet report. All Transactions ========== This sheet compiles a list of all transactions from every page into one list. Use the filter arrows on the headings to reduce the list down to the information you are looking for. Summary per Sheet ============ Select the sheet you want from the drop down box (below the Go To Sheet button) on the Summary per Sheet page. This produces a report with totals for each Budget and Account used on the sheet you have selected. You can then use this report to enter the budget and account totals into your accounting software (MYOB,Reckon)