General Ledger & EOM/EOQ/EOY Balances

For the small business that reports on a "Cash" basis. Fill in all receipts and payments for the month or the quarter into this journal and it will calculate your BAS Statement for you.

Worked example! A simple 10-column worksheet (partnership) MSExcel spreadsheet showing an initial trial balance with balances as per the ledger at the end of year (EOY) and showing simple adjustments to the final figures for pre-paid expenses, accrued expenses, accrued income, accrued special fees and charges, accrued unearned income, bad and doubtful debts written off, and depreciation, and highlighting adjustments using colour. Simplified but useful.

Bank Reconciliation Statement

A great place to start. Simple, easy to complete, budget workbook in Microsoft Excel, 15pp. Last year, this year's budget and a page for each month. Key in last year's actuals, month by month. Prepare the budget worksheet for the coming year, month by month. You now have a page for each month. Now just key in the actuals for the month and then explain the differences. Based on Chart of Accounts for a company Pty trading in goods and accounting worksheet for company Pty.

A great place to start. Simple, easy to complete, budget workbook in Microsoft Excel, 15pp. Last year, this year's budget and a page for each month. Sole trader. Small business. Key in last year's actuals, month by month. Prepare the budget worksheet for the coming year, month by month. You now have a page for each month. Now just key in the actuals for the month and then explain the differences. Based on Chart of Accounts for an individual contractor NAT 1908 working on the Internet and accounting worksheet for sole trader in the service industry.

For the small business that reports on an "Accrual" basis. Fill in all sales and purchases for the month or the quarter into this journal and it will calculate your BAS Statement for you.

A Trial Balance (in MSWord) based on the Chart of accounts for an NGO Charity Ltd (company limited by guarantee).

• Corporations Act 2001 (Cth)

A great place to start. Simple, easy to complete, budget workbook in Microsoft Excel, 15pp. Last year, this year's budget and a page for each month. Key in last year's actuals, month by month. Prepare the budget worksheet for the coming year, month by month. You now have a page for each month. Now just key in the actuals for the month and then explain the differences. This is for a national organisation and is therefore a company limited by guarantee. Based on Chart of accounts and an accounting worksheet for a charity NGO (non-government organisation).