nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Overpayment - Portion of credit allocated against invoice - General Journal Entry

KauvaiAdmin

Kia Orana!

I need some help please!

Transferring a customer overpayment from one customer to another customer via General Journal Entry.
First Entry : Dr PPA - $3K Cr Bank Clearing Account - $3K
Second Entry : Cr PPR - $3K Dr Bank Clearing Account - $3K
When I go to run Open Balance Report for PPR, it shows a portion of the overpayment being allocated to an invoice.

How do I correct this? - I do not want this overpayment linked to this invoice. They have sent through a remittance paying other invoices, and taking up the credit of $3K. I have yet to allocate their remittance.

I hope I am making sense - I am new to Reckon and still trying to find my feet:). I am using Reckon Accounts Hosted.

Any help would be most appreciated:)

Kind Regards,

Melinda

Comments

Kris_Williams

You would have to use the accounts receivable account and the customers name to link it, in the journal

Datarec

Hi @KauvaiAdmin

Based on the information provided, the most likely explanation is that the customer credit transfer was entered through a customer-related Accounts Receivable transaction (such as an A/R journal), which is causing the Open Balance Report to display the credit against an outstanding invoice.

This may be expected reporting behaviour rather than an actual allocation, but there isn't enough information yet to confirm that.

Next Steps

To better understand why the report is showing this result, could you please provide the following:

Which account was used on the customer lines of the journal entries?
- Was it Accounts Receivable, or a different account?
Which invoice is showing the allocation?
- Please provide the invoice number, date, or amount.
What dates were used for the two journal entries?
Have any other customer transactions been entered for PPR?
- For example, Receive Payments, Credit Memos, Customer Payments, or additional journals.
Can you provide a screenshot of the Open Balance Report showing the unexpected allocation?

Why These Details Matter

The account used in the journal, the affected invoice, and any existing customer transactions will help determine whether:

Reckon is simply displaying the available customer credit in the report, or
There is an actual transaction link or allocation that needs to be reviewed.

Once we have those details, we can provide a more accurate explanation of the behaviour and the appropriate way to handle the credit transfer.

KauvaiAdmin

Hello,

Transferred the credit overpayment from Pacific Resort Aitutaki to Pacific Resort Rarotonga - Both Accounts Receivable.
Invoice # is 25-15723.
Dates that the General Journal was processed - 30/07/2026.
Yes - Receive Payments & Customer Payments.
Screenshot as per below :

Thank you:)

KauvaiAdmin

In addition to the above query. We have received payment from PRR, dated 31/07/26. They are only paying invoice 26-15685 and taking up the credit of $3,963.95. There is only $3,191.75 of available credits. Part of the $3963.95 credit has been taken up by invoice #25-15723 - $772.20 - which is the difference. Is there a way to unlink invoice 25-15723? so available credits becomes $3,963.95 which is what I want. This will balance to the customers payment.

Thanks..

Datarec

For that general journal transaction, it only shows "Pacific Resort Rarotonga" on the Accounts Receivable line for the Name column. It makes no mention of the other customer name "Pacific Resort Aitutaki" on the Bank Clearing Account line.

Can you go to that PRR invoice 25-15723 and click on the History button to show what other transactions may be linked to it? Whatever it is, likely amounts to that $772.20.

KauvaiAdmin

Thank you Team!

Have managed to correct and allocate customers payment as per remittance.

Thank you and much appreciated:)

Datarec

Hi @KauvaiAdmin

Great to hear that you have resolved the issue.

Did you do anything differently to resolve the issue either via the General Journal transaction or did you simply unlink any payments to that specific invoice?

KauvaiAdmin

Hi Team,

Simply just unlinked the payment to that specific invoice, and it worked.

Thank you:)

Datarec

Hi @KauvaiAdmin

Thank you for sharing what worked for you as this will assist others who may come across this post in the future.

Reckon Accounts Hosted Announcements & Important Info

Check out the latest important info & announcements for Reckon Accounts Hosted

Button

View all Reckon software categories 🗃️

Each Reckon software has its own dedicated category on the Community. Click below to browse all categories.

Explore all categories