GST Spreadsheet

The spreadsheet is designed to be simple to use and easy to negotiate, a must for any small business.

Add to Cart Excluding 10% tax

Simple GST Spreadsheet

Major software companies charge hundreds of dollars for their complicated accounting systems, which in most cases are way beyond the needs of most small businesses.

Wouldn’t it be nice if there was a simple cheap alternative to the major accounting software companies? I believe this spreadsheet at a mere $25.00 (inc GST) is a great alternative.

This GST Spreadsheet, which has been downloaded by over 250 small businesses is designed for their operating needs, it helps to keep track of the GST collected and paid for each quarter as well as income and expenses for the end of year tax return.

Below, there are 3 screen shots showing the income and expenses and the totals page showing the quarterly and annual balances.


The spreadsheet is designed to be simple to use and easy to negotiate. It has 12 monthly tabs and a totals page. As the information is entered month by month and the totals page is automatically updated.

GST Spreadsheet Totals Page

To enter the income, enter the date, the total amount received and whether GST applies to the transaction. If the business is GST registered then in most cases GST will apply to all income. The GST and Sales columns are automatically calculated by the spreadsheet.

GST Spreadsheet Income


To enter the expense the date and description need to be filled and the total amount of payment entered. (14th March 2011, Fuel for Car, $55.00) . Enter the business percentage of the transaction. If the fore mentioned fuel is for a vehicle that is 100% for business then the business percentage is 100%. Should the vehicle be used for personal use then the applicable percentage should be used.

The GST and the amount to allocate will be calculated automatically. The figure in the amount to allocate will need to be allocated to one of the expenses in the yellow highlighted columns. There is a checksum at the end of the spreadsheet that looks at the “amount to allocate” and the “yellow highlighted columns” and if they are equal the checksum will display a “Y” otherwise it will display a “N” and the amounts entered in the “yellow highlighted columns” will need to be checked.

GST Spreadsheet Expenses

Once all the data has been entered for the quarter then it is a matter of going to the totals page and transferring the quarters totals to the Business Activity Statement.

Should you need to change the expense column description or the title of the page, this can be done by changing the description on the totals page. The changes are then applied to each month.

Instruction Video


Payment can be made by PayPal, please click the “buy now” button and follow the link to PayPal and make sure you return to this website to complete the transaction and receive the spreadsheet.

Also, if you want to pay via credit card or direct deposit, email me and I can organise payment and forward the GST Spreadsheet.


  • Be careful when copy and paste that you don’t copy and past the locked calculation fields, this will cause “#REF” errors.
  • Keep a back up copy of a blank sheet for use in future financial years.
Add to Cart Excluding 10% tax

*Please Note – The spreadsheet has been locked to avoid any accidental changes to the formulas contained in it, please do not request the unlock code as I will not pass it on.


  1. Hi, Its a great spreadsheet thanks. I don’t need half the expense columns. Can the unnecessary ones be deleted?

    1. Author

      Thanks, Barry deleting the unwanted columns would create errors with the formulas in the spreadsheet.

  2. hi

    Could you please tell me how to delete #REF! from cells E, G-J. I tried to cut and paste cells C 30 -37 to cells C7-14. But then #REF! came up in those cells and i cant delete them.


    1. Author

      The short answer is not to copy & paste locked cells, the cells will need to unlocked and the formulas re-entered

  3. Really love the spreadsheet, purchased for our BAS prep. Any way I could filter the spreadsheet to be in date order. I enter purchases as they come in so not all reflect straight away. I understand why certain cells are locked but this would be very handy.

  4. Hi – if I have missed a couple of entries and need to insert them before an entry that has already been lodged (put in date order), how can I move the row down to put the missing entry in?

    1. Author

      Kerry, before you make any changes save a separate copy of the work that you have already done.

      You can cut and paste all the fields except the locked ones, the locked fields should recalculate after you have copied and pasted. I haven’t tried this my self. Columns E, F, N and AI are locked. Cut and paste columns A to D and move down the required amount of rows, G to M and then O to AH.

      I hope you understand what I am trying to suggest, as I mentioned before make a back up should it all go wrong.



  5. I am in Canada and we also have GST, at what rate is the GST in this spreadsheet and can it be modified as and when/if the rate changes?

    1. Author

      Phil, the GST rate in Australia is 10% and typically paid quarterly. I can make the changes to the rates to match Canada’s rates assuming they are not the same as Australia.

  6. Hello,

    I’ve just purchased your 16 expense worksheet however as a psychologist in private practice doesn’t include as many expense items as required – does your 30 expense items includes things such as conferences, professional books/subscriptions etc.?

  7. Hi. I have recurrent expenses that I would like to cut-and-paste into each month, but I get a message saying the sheet is password protected.

    1. Author

      As soon as you try and past over the locked column of “% of total payment” it will display the “sheet is password protected” message. I have locked that column so the calculations of the spreadsheet aren’t compromised.

      All I can suggest that you do is to copy the information before the that field and paste and then cut and paste the information in the yellow highlighted columns.

  8. Hi – I have been using this spreadsheet for approx. the last 8 months and find it very simple to use… it has suited my needs perfectly.

    Recently the ATO made changes to my BAS/Personal Income Tax and I am now required to pay Income Tax in installments.

    I was just wondering if the spreadsheet can be update to calculate this information automatically?

    1. Author

      Simon, the ATO will either give you 2 options to the amounts to be paid on a quarterly basis, either a set amount or a percent of your income after GST.

      Both options are relatively easy to calculate at the time of preparing the BAS and the percentage and set amount are displayed on the BAS form.

      I am quite happy to discuss further and make some additions to the spreadsheet, email me at with details of the addition you would like to see.



      1. Hi Geoff
        Can this app also record inventory and produce invoices ??

  9. Hello, I have just purchased your spreadsheet. I began entering data in the Income column. The first date entered okay, from then on the date entered as a random number, like 42202, even though I entered 17/07/2015. Also, can I add a column for “description” under Income? Further, how do I customise my expenses categories? Thanks.

    1. Author

      Hi David, you can the date by doing the following, Select the cells you want to format, Press CTRL+1, In the Format Cells box, click the Number tab, In the Category list, click Date and choose the format that you want.
      To change the catagories for the expenses, go to the totals page and change to column headings there, the new heading will be reflected through the the monthly tabs. Put the most popular expenses in the first columns
      Unfortunatley at the moment there is no provision for description in the sales column, it mat be a field that I will add.

  10. Hi I have been using erecord for many years but comp crashed and all is lost. I am now using a new Mac comp and was wondering if I can use your GST spreadsheet program to replace erecord. The only question I need to know is I have a business offset account that I move funds out of or into my company account. It is under the company name as well but that account pays interest so when my company account has more than the needed operating capital it is transferred out. If short in company account or for has payments etc it is transferred back. Does your GST spread sheet have the ability to split that input and not recognise it as income. I don’t want to be paying tax on the same income twice. If it can I will purchase your program.

    1. Author

      The spreadsheet is simple and any splitting of income and expenses will need to be done mannually. Also if a deposit isn’t income then do not enter on the spreadsheet.

Leave a Reply to David Wadelton Cancel reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.