Get topic updates

  • How to correct a duplicate or unpresented transaction

    Every transaction is included in GST returns, regardless of whether it’s been reconciled or not, which means that sometimes a transaction might sneak into a GST return when it really shouldn’t.

    This includes:

    • Duplicate transactions
      This is an accidental double up of transactions and can occur when transactions have been entered in two different ways.

    For example, you may have manually entered a transaction from an invoice and also automatically imported the transaction from the bank feed, giving a double up of a transaction.

    • Unpresented transactions
      Transactions that have been entered into Cashmanager but haven't happened at the bank i.e. unpresented cheques

    You can delete these types of transactions before they are locked into a finalised GST return.

    However, if they are included in a GST return you will need to create a reversal transaction to 'remove' it.

    The reason for this is any changes to the original transaction will invalidate the GST return and it will no longer match what was filed with IRD.

    How to create a reversal transaction

    1. Find the duplicate or unpresented transaction
    In the Transaction screen you can use the Filter button 0_1495417194726_64d00b19-f296-4c29-b7b6-fc69d04e4266-image.png to find these transactions.
    They will generally be unreconciled, so tick the Unreconciled button to display these transactions.


    2. Transaction details
    Note down the transaction date, amount(s), other party, and coding of the transaction.
    You will use these details to create the reversal transaction.

    TIP: Make sure to note whether it is an expense or income transaction, as the reversal will need to be the opposite.

    3. Create the reversal transaction
    To create a reversal transaction you will need to create the opposite to the original transaction e.g. if it was an income transaction your reversal would be an expense transaction and vice versa.

    Scenario: Dan accidentally records his Countrywide subscription twice in the Transaction screen. They're then included in a finalised GST return. He needs to create a reversal transaction (an income record) to balance out the duplicate transaction (an expense record).


    1. To reverse an expense transaction, click on the Income button at the top of the transaction screen.

    2. The Transaction date, Amount and Other Party should be the same as the original transaction.

    3. Record the same category and extended code as the original transaction.

    4. Record a clear note the explains why the reversal was created.

    5. Click Ok to save the reversal transaction.

    For reversal transactions that are made up of multiple lines have a look at the topic multi-line transaction.

    Don't forget to...

    Reconcile the original transaction and the reversal. This helps to keep your database tidy and will let you close the current financial year once the new year rolls around.

    Don’t worry though, because they zero each other out, reconciling them won’t affect your accounts.

    How will this affect my GST?

    The reversal transaction will be pulled into your next GST report so that the GST portion can be claimed and correct the incorrect claim in the prior return. The previous GST report remains unaffected by the reversal transaction.

    Related Topics

    How to correct an incorrectly coded transaction
    How to edit or delete transactions

  • Comments

Log in to reply