Search
Close this search box.

Bookkeeping

How to Series No 4 – How to Account for Hire Purchases

This is the fourth part in a series I’m calling “How-To”. The first part was about insurance bills, the second part was about VicRoads registration bills and the third part was about chattel mortgages. I will be using Xero for the example, but don’t worry if you use another software, the basic rules will still apply. 

The fourth how-to is about how to account for hire purchases in your accounting software. A hire purchase arrangement is an agreement to purchase goods in instalments.

Step 1

Let’s pretend that your business has purchased a new printer with all the bells and whistles for $15K via a hire purchase agreement, plus $5,000 interest.  For this example, the hire purchase is for 30 months without a residual (balloon) payment at the end of the period. Note, that most hire purchase agreements will include a balloon component (check your documentation). The first thing to do is collect all of the documentation. You will need the hire purchase agreement, the invoice, and the interest amortisation schedule. The hire purchase company will provide all of this to you at the point of purchase. To begin the process, create some accounts in your accounting software:

  • Office Equipment (Asset GST Inc)
  • Hire Purchase Unexpired Interest (Liability GST Inc)
  • Hire Purchase Liability (Liability BAS Excluded)
  • Interest Expense – Hire Purchase (Expense BAS Excluded)

Note, For any Hire Purchase Agreement made after 1/7/2012, both the purchase price of the asset and all interest charges and fees are subject to GST. (see notes at the end of the blog)

Step 2

Now you can enter this journal which adds the purchase of the printer into the accounts:

Check your balance sheet. It should look like this:

Step 3

When it comes time to record the first repayment to the finance company, your entry will look like this (assuming each repayment is $500 (30 x $500 = $15K)). Note, that the tax code for the interest expense account is BAS Excluded. This is because the GST on the interest component of the hire purchase was claimed when the purchase was entered initially (see journal). Therefore the monthly repayments of interest are not reportable on the BAS.

Step 4

Check that the balances in the balance sheet are reduced by the first repayment – see below. Note that I have evenly split the interest repayments into amounts of $151.51 for this example ($4,545.45 divided by 30 payments). However, you will need to enter the interest amounts as per your amortisation schedule and these won’t be exactly the figures divisible by the number of repayments. Something to keep in mind!

GST rules for hire purchases

For hire purchase agreements entered into on or after 1 July 2012, all components of the transaction are subject to GST including:
• The upfront purchase price of the asset financed under the agreement
• Interest charges, and
• Any other associated fees.

This is the case regardless of whether you account on a cash or accrual basis.

This means that taxpayers on a cash accounting basis can claim the full amount of any available GST credit at the time the first payment is invoiced or paid under the hire purchase.

This was the last part of our How-To series (for now). I hope you found this series useful. For further details about hire purchase agreements and GST, go to this ATO webpage.

Like it? Share it!

How to Series No 4 – How to Account for Hire Purchases Read More »

How to Series No 3 – How to Enter a Chattel Mortgage Asset Purchase & Loan

This is the third part in a series I’m calling “How-To”. The first part was about entering insurance bills and the second part was about how to enter a VicRoads registration bill. I will be using Xero to present the example, but don’t worry if you use another software, the basic rules will still apply. 

The third how-to is about how to enter a Chattel Mortgage asset and associated loan into your accounting software.

Step 1

Let’s say your business has purchased a new motor vehicle. The invoice from the vehicle dealer might look something like the below example. Grab your invoice now.

Step 2

The finance company loan schedule is also required. It may look something like the below example. Grab you loan schedule now.

Step 3

Create the following accounts in your software (check first because some may already exist):

  • Deposit Paid (Current Asset) – no tax code
  • Motor Vehicles at Cost (Non-Current Asset) – apply capital expense including GST tax code
  • Chattel Mortgage (Motor Vehicle) (Non-Current Liability) – no tax code
  • Chattel Mortgage Interest Charges (Expense) – no tax code
  • Chattel Mortgage Fees & Charges – tax code varies, could be Free or GST inclusive (check your documentation)
  • Motor Vehicle Registration (Expense) – apply GST Free tax code
  • Motor Vehicle Insurance (Expense) – apply GST inclusive tax code
  • Unexpired Term Interest (Non-Current Liability) – no tax code

Step 4

First enter a spend money transaction to record the payment of the deposit:

Step 5

Next, enter this journal to record the purchase of the new vehicle:

Step 6

When it comes time to make a repayment to the finance company, enter a spend money transaction like this:

Bonus Tip!

Sometimes it isn’t possible to obtain the loan repayment schedule for whatever reason. When this happens, you need to create your own. I use this amortisation calculator by Bret Whissel. It has served me well over the years. I hope you find it useful too.

Next week for part four of this How-To series, I will cover how to set up a Hire Purchase agreement in your accounts. Until then, happy bookkeeping!

Like it? Share it!

How to Series No 3 – How to Enter a Chattel Mortgage Asset Purchase & Loan Read More »

How to Series No 2 – How to Enter VicRoads Registration Bills

Last week, I started a bookkeeping resource series called “How To”. Each week I will share instructions with you about how to enter some common transactions. I will be using Xero to present the example, but don’t worry if you use another software, the basic rules will still apply. Last week I explained how to enter an insurance bill.

The second how-to is about how to enter a VicRoads registration expense/bill into your accounts.

Step 1

Grab your VicRoads bill and go to the part where it shows you the breakdown of charges. It may look something like this:

Step 2

Log into your software and go to the area where you enter bills.

Step 3

Enter the VicRoads as the supplier, the relevant dates and the reference number or name as below:

Step 4

Enter a line in the bill for each charge shown on the bill. The registration fee is GST-free, the TAC charge includes GST and the insurance duty is BAS Excluded. If you are entitled to claim 100% of motor vehicle costs in your business, then you can claim the full GST amount on the TAC charge. Time and time again, I see clients entering the full amount of the registration expense as GST-free. While they are partly right, they are also missing out on claiming the GST of the TAC charge. Also, relevant here is the choice of account for expense coding – you may like a general account such as this one “Motor Vehicle Expenses”, or you may like to split your costs out in a more detailed manner and have an account for each type of car expense, in this case, “Motor Vehicle Registration”. It just depends on how much detail you want to see in your profit and loss report.

Step 5

Check that the GST amount agrees with the VicRoads bill. In this case, it is $40.00.

Step 6

Approve the bill to ensure the expense is added to the accounts correctly.

Final words…

So that’s it for this week’s “how-to”. I hope you learned something new. One thing I’d like to add about VicRoads “bills” before I close off this blog, is that to obtain an actual bill, you do have to have an account with VicRoads. They used to send out the document in the mail, but not anymore – it’s all online, like everything these days. Here’s the link to VicRoads where you can make an account if you haven’t already done so.

Bonus Tip!

For any bookkeepers out there who know the pain of not ever receiving an actual VicRoads bill from clients (who probably don’t know how to get it – see notes above), which makes data entry nearly impossible, here is the link to the TAC registration rates for FY24. This document provides the breakdown of TAC and insurance duty fees based on postcode and vehicle type. An excellent resource that I am sure you will use time and time again. There is also an online calculator you can use on the VicRoads website that will provide the figures you need easily. Here is the link for the calculator. Either resource will get you the information you need. You’re welcome by the way!

Next week I will show you how to enter a chattel mortgage loan. Until then, have a happy week.

Like it? Share it!

How to Series No 2 – How to Enter VicRoads Registration Bills Read More »

How to Series No 1 – How to Enter an Insurance Bill

This week, I am starting a bookkeeping resource series called “How To” (not very original, I know!). Each week I will share instructions with you about how to enter some common transactions. I will be using Xero to present the example, but don’t worry if you use another software, the basic rules will still apply.

So here goes, the first how-to is about how to enter an insurance bill into your accounts the right way.

Step 1

Grab your insurance bill and go to the part where it shows you the breakdown of charges. It may look something like this:

Step 2

Enter a line in the bill for each charge shown on the bill. In this case, there is one for the premium and one for the stamp duty component. Select the insurance account you want to use – you may have one for business insurance and another for motor vehicle insurance etc. Notice that the premium figure is plus GST, whereas the stamp duty is BAS excluded. This is because stamp duty does not attract GST. It is very important to break up your insurance bill like this and to never enter a bill 100% inclusive of GST. Doing so will mean that you overclaim GST in your BAS.

Step 3

Check that the GST amount agrees with the insurance bill. In this case, it is $38.25 which is one cent less than our bill, hence the rounding line I have added to agree the total amount with the supplier’s bill.

Step 4

Approve the bill to ensure the expense is added to the accounts correctly.

Final Words…

So that’s it for this week’s “how-to”. I hope you learned something new. Please note that this insurance example is pretty basic. Some insurance bills have extra charges which may or may not include GST. The trick to getting these sorts of more complex bills entered correctly is to ensure the GST figure in the bill agrees with your software entry. If it doesn’t, you need to check each charge for its GST status i.e. some items will include GST and others may be GST-free or GST-exempt.

Next week I will show you how to enter motor vehicle registration bills. Until then, have a happy week.

Like it? Share it!

How to Series No 1 – How to Enter an Insurance Bill Read More »

Bookkeeping & tax podcasts I love!

Over the last couple of years, I’ve moved away from written content to podcasts as my preferred choice of learning and research. Podcasts are great because you can listen to them at any time, doing anything, and privately, too, if you use earphones or earbuds. I usually walk daily and listen to a podcast at the same time – getting my exercise and racking up CPE points simultaneously – win-win!

I have many interests and there are podcasts for just about any topic you can imagine. Being a bookkeeper, I have found several podcasts about tax and bookkeeping, and over the years, have narrowed the list down to three podcasts that resonate with me the most. Here is my list:

  1. Two Drunk Accountants: This podcast is hilarious! If you thought that accounting and tax topics could never be interesting or even funny, you are in for a big surprise!  Tim Garth and Dan Osborne of CATS Accountants are the voices behind this thoroughly entertaining podcast. I find that I am laughing from beginning to end but am being educated at the same time. I enjoy this podcast and you will too! Here is the link to hear the boys bang on about their industry and their lives in general.
  2. ICB News Channel: The Institute of Certified Bookkeepers has a podcast that is published monthly, based on topics from their newsletter. Rob Marshall, the Support and Resource Manager at ICB, runs the podcast which often includes interviews with current stakeholders involved in the bookkeeping industry. If you want to keep up with the changing face of bookkeeping and also top up your CPE points, this podcast is the one to choose. Find this podcast here.
  3. Tax InVoice: This podcast is delivered by the ATO. Certainly not as entertaining as the Two Drunk Accountants (because let’s face it, “Two Drunk ATO Tax Specialists” doesn’t have the same ring!), the podcast will dot the i’s and cross the t’s so far as covering many tax issues and topics. Covering everything from working from home to crypto assets, Tax InVoice is a purely tax-based podcast but I find it is an easier platform to use to try and understand tax topics which can be difficult to do via written text only. You can find the 50-plus episodes of Tax InVoice here.

I’m sure if you search, you’ll find many other bookkeeping/tax podcasts. As I said earlier, I did follow about 6 or 7 back in the day but have slowly removed the ones that I didn’t find useful or enjoy. There aren’t too many Australian tax podcasts really, so if you do a search, you’ll probably find several American-based ones. These ones have their place, but if you’re after Australian tax information, you need to ensure you choose Australian podcasts. I hope you find this information useful and if you haven’t delved into the world of podcasts yet, perhaps you can start with one or two from my list.

Do you listen to a bookkeeping podcast that you think is great? Why not share it with other readers in the comments section below?

Like it? Share it!

Bookkeeping & tax podcasts I love! Read More »

10 Ways Bookkeepers Can Use ChatGPT

Unless you’ve been living under a rock, you would undoubtedly have heard the term artificial intelligence or “AI”. AI is the new buzzword and seems to be everywhere you look. In particular, most accounting software, and many other apps have embraced AI and have made it a part of their interface.

While some may be dubious about AI (even afraid), the fact is, that it is here to stay and has been a part of the way we use technology for a long time. Google apps including Gmail and GDrive, apps like “Grammarly” and other apps that make suggestions as you type, for example, are all using AI to enhance the user experience and basically make life easier. 

Given AI is already here and we use it daily (even though we may not be aware of it), I have started to wonder how bookkeepers can use it to assist with daily tasks. To that end, I have done some research into how we can use ChatGPT for this purpose.

What is ChatGPT?

ChatGPT stands for Chat Generative Pre-training Transformer. It was launched in November 2022 and is a remarkable text-based chatbot. It enables users to effortlessly type queries and receive accurate answers, as well as efficiently complete tedious tasks. This advanced chatbot is trained with extensive data, allowing it to generate responses that closely resemble human-like interactions. You can download the ChatGPT apps from your favourite app store.

So now that we know what it is, how can bookkeepers use ChatGPT? There are actually many ways to use it, but here are 10 ideas to get you started. 

    1. Writing those “difficult” emails to clients. Sometimes as bookkeepers, we need to tell our clients they have to go, or we are putting our prices up or we found something dodgy in their accounts, etc. Ask ChatGPT to write the email for you by telling it what the email is about. You will receive a professionally written email script in seconds.
    2. Creating Excel formulas. Tell ChatGPT what you want to calculate in a cell or column and provide the data to work with and it will create the formula for you. Here is an example of how this might work.
    3. Creating journal entries. ChatGPT can extract information from receipts, such as dates, seller names, and amounts. Just provide the dataset, and ChatGPT will analyze it and input the client information for you. More specifically, the prompt you would use would be: “Use the following transaction details (add transaction text) and amount to create a journal using these account names (Add accounts) using (Add accounting system)”
    4. Creating checklists and subtasks. Ask ChatGPT to create a list of steps to complete any bookkeeping process. The result can be modified to suit your needs and business. You can also ask it to create subtasks for each of the steps inside a checklist.
    5. Creating client questionnaires. Ask ChatGPT to suggest a list of questions to ask new clients during client onboarding.
    6. Creating client onboarding checklists. Ask ChatGPT to create a checklist for you when onboarding a new client. You can tell it some basic details like number of employees and business structure.
    7. Creating an engagement letter. Ask ChatGPT what to include in an engagement letter for a client with XYZ requirements. Adjust to suit your business requirements.
    8. Staff onboarding checklist and letters of offer. Ask it to create a checklist for onboarding staff either for your business or for a client. Also, ask it to create letters of offer based on the details you provide. Adjust to suit your business.
    9. Creating email templates. Make a list of the type of emails you write continuously e.g. a request for information. Ask ChatGPT to write these emails for you. Update the details to suit your business and then save them as templates.
    10. Creating copy for your blog or website. Tell ChatGPT what you want to write about e.g. ideas for your About Page. Ask it to write you the copy for this page. You can do the same thing for your blogs. Simply provide it with some basic information e.g. how GST applies to food sales in Australia, and ask it to provide you with copy for your blog. Of course, you should check the details it delivers for accuracy and currency before publishing.

    I hope these ideas, or “prompts” as they are known, give you the motivation to start to play around with ChatGPT in your bookkeeping business. Obviously, the sky is the limit regarding what you can do with ChatGPT. I’m sure once you get started, you will discover many more ways to use it in your business. If you would like to share any prompts you currently use with ChatGPT, please add them below in the comments. I’m sure other bookkeepers would love the extra motivation!

    Like it? Share it!

    10 Ways Bookkeepers Can Use ChatGPT Read More »

    eInvoicing: what is it and how to get started

    What is eInvoicing?

    eInvoicing is a new way to securely send and receive invoices between businesses via a secure global public network known as PeppolThe Australian Peppol Authority is the ATO. eInvoicing, despite being a popular and efficient method of transacting, is not mandatory.

    A buyer and a supplier must both be registered with Peppol in order to use eInvoicing. This is done via your accounting software (if it offers eInvoicing functionality). Larger businesses may need to use alternative options in order to connect to the network.

    Why eInvoicing?

    eInvoicing is secure and time-efficient. It removes the need for using email or snail mail as methods of sending invoices and therefore, is more secure. It also removes the need to key in invoice data when an invoice is received and/or scan and attach PDF copies of the invoice. Data entry error is also heavily reduced when using eInvoicing due to little or no keying in of details required. When an invoice is received via eInvoicing, you would simply go through your normal approval process and then prepare to pay the invoice when ready. The below image is from the Institute of Certified Bookkeepers and explains the difference between the current invoicing process you probably use now, and the eInvoicing process which is much simpler.

    /

    How do I know if my supplier or customer is eInvoicing-enabled?

    When you or your supplier becomes eInvoice-enabled, you will be listed in the Peppol Directory. You can search the directory to see if your contact can receive or send eInvoices.

    How do I know if my software product is eInvoicing-ready?

    All software products that offer eInvoicing functionality are listed in this register on the ATO website. Some products are accounting packages and some offer online web portals for eInvoicing. 

    Below are 3 of the most popular online accounting packages which are eInvoicing-ready now. Each software link below will assist you to get started using eInvoicing and explain the process specific to that software. It’s important to note that MYOB and Xero do not charge anything extra to use eInvoicing which is excellent! Reckon has monthly packages including eInvoicing.

    Not ready to commit to eInvoicing? Need more information?

    eInvoicing is relatively new, although large companies and government departments have been using it for quite some time now. Small businesses are slowly engaging in this new method, with the uptake increasing continually. It is understandable that you may not be ready to make the jump to eInvoicing or even require it at this stage in your business development. If you would like to do some further research before moving forward, here are some useful links:

    Like it? Share it!

    eInvoicing: what is it and how to get started Read More »

    ATO has recommenced tax & super debt Collection Activities…

    What you can do to help yourself and/or your business

    During the past 2 years of the COVID-19 pandemic, the ATO deliberately halted tax and super debt collection in order to assist businesses and taxpayers affected by the pandemic’s consequences.

    But now they are back on the bandwagon. Debt collection has recommenced!

    The ATO is clear that if you engage with them as soon as possible, they will try to work with you to help you manage your debts. However, and I quote:

    Where taxpayers don’t engage, the ATO is taking firmer actions. These include garnishees, recovery of director penalties, disclosure of business tax debts, and legal actions including summons, creditors petition, wind-up, and insolvency action.”

    So the message is don’t hide under a rock. The debt won’t disappear and the ATO will chase you to recover it. Instead, contact the ATO immediately and work with them to resolve the issues. They can’t help you if you don’t communicate with them. Your tax or BAS agent can do this on your behalf if you would prefer not to call the ATO yourself.

    It is important to note that from July 2022, any tax refunds or credits will be automatically applied to any tax/super debt you may have, meaning that you may not receive any refund or a smaller refund than expected.

    The ATO has various avenues of help for businesses or taxpayers experiencing tax/super debt stress. Some of these are listed below:

    Like it? Share it!

    ATO has recommenced tax & super debt Collection Activities… Read More »

    How to lodge a TPAR non-lodgement advice form (NIL TPAR)

    If you normally lodge a Taxable Payments Annual Report (TPAR) but have decided that this year, you don’t have anything to report, you can lodge a “Non-lodgement Advice” form (NIL TPAR) with the ATO. You can do this online via ATO Online Services.

    If you are a sole trader or individual taxpayer you can access Online Services through your myGov account. If you are another structure, such as a company, you can access Online Services via Online Services for Business.

    Submitting a TPAR non-lodgement advice form,

    • allows you to notify multiple years on the same form
    • allows you to advise when you do not need to lodge in the future
    • allows you to give a reason for not lodging
    • validates information entered
    • provides a reference number for confirmation
    • appears in the lodgment history tab.

    If you are not sure if you need to lodge a TPAR or not, go to this ATO webpage which will help you work this out.

    Like it? Share it!

    How to lodge a TPAR non-lodgement advice form (NIL TPAR) Read More »

    Travel Diaries

    Finally, after the dark days of COVID-19 and endless lockdowns, etc., we are now seeing glimpses of opportunities to travel again (THANK GOD!). For business owners, this means work-related travel is once more on the table. Given it’s been a while between trips, I thought it might be useful to provide a refresher on travel diaries and when they are required.


    When do I need to keep a travel diary and what do I record?

    When you travel for work or your business, you are sometimes required to keep a travel diary as per the ATO to assist in working out which part of your travel is tax-deductible. I have outlined the circumstances below which would dictate when you should keep such a diary:

    You should include the following in the diary:

    • Your location
    • The nature of the activity e.g. a conference
    • The day/s and time/s (start and end times)
    • The length of the activity e.g. 2 days
    • When you stopped for meals
    • Travel movements and activities before the activities end, or as soon as possible afterwards
    • The entries must be in English

    What can I use as my travel diary?

    The ATO has said that you can use a diary or journal of your choice for the purposes of keeping a travel diary. You can also use your digital calendar as well, making sure to attach receipts/invoices to each entry.

    What other records do I need to keep?

    It goes without saying, that you should keep all receipts and invoices related to your travel as well as the travel diary. This will make both the bookkeeper’s and tax agent’s jobs much easier 🙂 and make the ATO very happy!


    Lastly, you need to remember that if you were required to keep a travel diary and you didn’t, then you may not be able to claim the relevant travel expenses on your tax return! Speak to your tax agent for further advice if this affects you. 

    Like it? Share it!

    Travel Diaries Read More »

    Scroll to Top