Cashbook v.01
| 
This spreadsheet has been designed for a business that has no employees. It is aimed at businesses such as sole traders and partnerships that do not employ staff. Typical users could be contractors, and other service based business. Cashbook Version 01 requires the user to be able to readily determine their total sales for the period from their invoice books or bank statements
Basic assumptions:
- Business accounts for GST on a Cash Basis of Accounting
- Business accounts for GST on a quarterly basis.
- Is able to calculate sales readily from invoice books or bank statements.
Sales
This version will not allow you to enter detailed sales transactions. It is useful for businesses that can readily identify their sales from other records. This could include their bank statements and or invoice books or their daily sales records.
Purchases
Will readily record up to 155 transactions per quarter. This can be extended by following the instructions contained within the spreadsheet.
BAS
Will assist you to determine your GST liability, by calculating the figures you enter. Each work sheet that records either the sales or expenses shows the relevant BAS label if applicable.
Download
Download Cashbook v01 by clicking on this link. This version is compatible with microsoft excel 2007+