CPA Logo

The GSTJournal

The GSTJournal is a simple journal spreadsheet for Microsoft Excel that will handle both cash and accrual based accounting. What is different about it is that the GST is analysed transaction by transaction, cause and affect are in close proximity and there is extensive GST error checking compared to most accounting programs

The GSTJournal has been designed to help clients keep records suitable for the preparation of a tax return and preparation of BAS statements. It works on either an accruals or cash basis. It is not suitable if invoicing and/or stock control are required although these are planned for later versions.

The GSTJournals are written in Microsoft Excel spreadsheet language. If you insist we may be able to export them to other formats. The books (worksheets) are divided into a cash receipts / payments journal (cashbook), a debtors / creditors reportl, a job cost for client report, a BAS and profit and loss report.

All data on either a cash or accruals basisis can be entered into the cashbook and this can cater for up to four different bank accounts. The other worksheets provide the reports. The BAS report gives all the figures to prepare a monthly, quarterly or yearly BAS statement. The report worsheet provides a standard Profit & Loss and Balance Sheet which can be easily edited in a word processor after a copy and paste to provide the desired formatting. The debtors and creditors report and job cost report provide limited subsidiary accounting reports which could be useful to businesses that do not need a more expensive ledger system such as MYOB or Quicken.