Accounting 5.0 was released by Community Capacity Accounting in March 2023 as an update to version 4.1.
While previous versions had a number of sub-versions (such as with or without GST, Charity or non-Charity), 5.0 features a set-up sheet that adds functionality to the workbook as needed by the user.
The workbook has these tabs:
Set-Up Sheet: Here you set up the spreadsheet with the functions you need, including the dates for your financial year. You can add more later.
Account List Sheet: Your ‘Chart of Accounts”: This is where you create new expenditure, income, asset or liability accounts. This sheet also has the list of account codes you need to work your transaction sheet.
Transactions Sheet: Records all your financial transactions and reconciles up to four bank/cash/credit card accounts. This is where you enter all your expenditure and income, including purchase of any fixed assets and any transfers between accounts.
Reporting Sheet: You can generate financial reports from here, such as a report for your committee meeting, or your figures for the end of the year.
Report 1 and 2 Sheets: Any reports created from the Reporting Sheet will be displayed here.
Journal, I-E Ledgers, Bal Ledgers and General Ledger Sheets (dark brown): These sheets are used only to make credit or debit adjustments and to provide figures needed for audit and end-of-year Financial Statements. You will not need these sheets for your day-to-day work!
All sheets have some protection to help avoid accidental entries or mistakes. If you want to remove this protection in order to customise the sheet for your needs, please contact CCA for a password. Note that CCA will not support any modified spreadsheets.
Further tabs are added depending on the settings in the Set-Up Sheet:
GST Returns Sheet: Tracks GST paid and received and gives you the figures you need for any GST returns.
Grant Sheet: Tracks any money unspent from conditional grants you may have received, and any untagged funds. You can generate grant reports here. This is where you add any funders.