GST Spreadsheet

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

Add to Cart

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 $16.50 (ex GST) is a great alternative.

This GST Spreadsheet, which has been downloaded by over 100 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.

Income

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

 

Expenses

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

Payments

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.

Add to Cart

*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.

14 thoughts on “GST Spreadsheet

  1. 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.

    • 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.

  2. 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.

    • 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.

  3. 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?

    • 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 geoff@accountantplus.com.au with details of the addition you would like to see.

      Regards

      Geoff

  4. 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.

    • 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.

  5. 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.?

Leave a Reply

Your email address will not be published. Required fields are marked *