{"product_id":"sole-trader-bookkeeping-and-bas-workbook","title":"Sole Trader Bookkeeping and BAS Workbook","description":"\u003cblockquote\u003e\u003cp\u003e\u003cstrong\u003eCheck with your accountant.\u003c\/strong\u003e This template helps you organise your own figures. It is general information, not tax or accounting advice. Have your accountant or registered tax agent check your figures before you lodge or submit anything to a tax office or any other authority.\u003c\/p\u003e\u003c\/blockquote\u003e\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e The ATO expects every business record to show a date, an amount, a description and the GST. Accounting software does that, and a great deal more than one person needs.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of income and one list of expenses in Excel. Each line gets a GST treatment from a short dropdown. The workbook adds up G1 total sales, 1A GST on sales and 1B GST on purchases for each quarter of a July to June year, and shows your profit or loss by month.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eRecord each amount you receive or pay once, with its date, description and GST treatment.\u003c\/li\u003e\n\u003cli\u003eRead G1, 1A, 1B and 1A minus 1B for each quarter, with cents and in whole dollars.\u003c\/li\u003e\n\u003cli\u003eSee profit or loss by month, by your own expense categories, without GST.\u003c\/li\u003e\n\u003cli\u003eSee income, expenses and profit for the year so far, and the GST position for the current quarter, on one dashboard.\u003c\/li\u003e\n\u003cli\u003eSpot lines with something missing: a Check column flags a missing date, GST treatment, category or tax invoice.\u003c\/li\u003e\n\u003cli\u003eRun a ten-point checklist at the end of each quarter and print the BAS Summary for your accountant.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHow it works\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eEnter your business name and the year your financial year starts. Change the expense categories to suit you.\u003c\/li\u003e\n\u003cli\u003eAdd a line for each amount received and each business cost paid, as they happen.\u003c\/li\u003e\n\u003cli\u003eAt the end of the quarter, read the BAS Summary and have your accountant check it before you lodge.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Sole traders in Australia who are registered for GST, report it quarterly, and want a spreadsheet instead of accounting software.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Businesses with employees or stock systems, anyone who wants bank feeds, invoicing or automatic lodgement, and anyone not registered for GST in Australia.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat it does not cover\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003ePAYG withholding and PAYG instalments, which appear on the same BAS form.\u003c\/li\u003e\n\u003cli\u003eFuel tax credits, wine equalisation tax and luxury car tax.\u003c\/li\u003e\n\u003cli\u003eBAS labels other than G1, 1A and 1B (for example G2, G3, G10 and G11, which the full reporting method asks for).\u003c\/li\u003e\n\u003cli\u003eRefunds, credit notes, bad debts and other adjustments to an earlier BAS.\u003c\/li\u003e\n\u003cli\u003eSplitting a cost between business and private use. Enter only the business part.\u003c\/li\u003e\n\u003cli\u003eChoosing between the cash and non-cash basis, GST instalments, and annual GST reporting.\u003c\/li\u003e\n\u003cli\u003eYour income tax return, depreciation, wages and super.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eIt does not choose a GST treatment for you, and it does not lodge anything. 1A minus 1B is a working figure: your BAS may include other amounts.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you need.\u003c\/strong\u003e Microsoft Excel 2016 or later. No macros, no add-ins, no subscription and no AI.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eGood to know\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAmounts are entered as actually paid or received, including any GST. GST is worked out as one-eleventh of an amount marked GST included. Where an invoice shows a different GST amount (phone, insurance, council bills), you type it.\u003c\/li\u003e\n\u003cli\u003eYou enter the date that applies to your accounting basis (cash or non-cash). Confirm your basis with your accountant.\u003c\/li\u003e\n\u003cli\u003eThe expense categories are a starting list for you to edit. They are not the labels of any tax return.\u003c\/li\u003e\n\u003cli\u003e1,000 income rows and 1,000 expense rows are ready, and you can extend either sheet by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eOne workbook covers one July to June financial year. Use a fresh copy each year.\u003c\/li\u003e\n\u003cli\u003eNothing is locked or password protected.\u003c\/li\u003e\n\u003cli\u003eGST rules are current as at 14 November 2026. The ATO pages each rule came from are listed inside the workbook and the guide.\u003c\/li\u003e\n\u003cli\u003eGeneral information only. It is not accounting, tax, legal or financial advice.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859261272269,"sku":null,"price":29.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover.png?v=1795090063","url":"https:\/\/www.teleworld.online\/products\/sole-trader-bookkeeping-and-bas-workbook","provider":"TeleWorld Online","version":"1.0","type":"link"}