How can a Sales Receipt have an open balance?

CarrieCook
CarrieCook Member Posts: 2 Novice Member Novice Member

I have a sales receipt from 2019 which has an open balance. The sales receipt has the payment format and Deposit To fields filled correctly. The history button shows that the amount has been processed in the 'Deposit' screen. The deposit has been batched and physically received in our bank account. Why would it show an open balance? How can a sales receipt even have an open balance. Most importantly, how can I clear it?

Thanks.

Comments

  • Acctd4
    Acctd4 Accredited Partner Posts: 4,217 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited February 2022

    Where are you looking that shows an open balance for it? 🤔

    (Unlike Tax Invoices) Sales Receipts don’t usually zero out because their amounts aren’t “owing”.

    (Think of it this way, when you make a purchase at a shop & get a receipt, it’s a record of the sale, so - even with your payment also shown on it - it still always shows the sale total, not a balance of $0)

  • CarrieCook
    CarrieCook Member Posts: 2 Novice Member Novice Member

    Hi Shaz, Thanks so much for taking the time to answer my query.

    image.png

    Hope the image is clear enough. Yes, the payment sales receipt was processed on 12/09/19 and then a payment was processed again on 17/9/19, error on our part which left the account in credit. The issue is the open balance of the sales receipt.

    Thanks again.

  • Acctd4
    Acctd4 Accredited Partner Posts: 4,217 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited February 2022

    Hi Carrie

    Ah, yep ... This is normal & is just a display anomaly - the Sales Receipt doesn't (& can't) actually have an open balance due to being a sale+payment-in-1 (see explanation previously) but will always display the amount in that column in the Customer Centre transactions list.

    What I AM noticing from your screenshot though is that separate "Payment" transaction for the Sales Receipt. THIS is the transaction that's the problem! A Sales Receipt is a "Tax-Invoice+Payment-in-1" eg It records both the sale AND the payment at the same time on the one Sales Receipt so entering an additional "Payment" transaction has doubled up. Check that the "Payment" transaction isn't reconciled (it shouldn't be as it should be the Deposit linked to the Sales Receipt that you cleared when reconciling) & then delete that Payment!

    IMPORTANT: When a "Payment" transaction - & this applies for Bill & Credit Card payments too - shows as a Credit or "Open Balance", it means it hasn't been allocated to its corresponding sale (invoice) /purchase (bill) . Unallocated payments will NOT show up on Cash basis Tax Reports so will inadvertently be omitted from your BAS! Therefore, always check your A/R & A/P reports prior to monthly/quarterly BAS completion to ensure all payments have been applied first.