Matching bank import data to invoice payments from customers

  • 2
  • Question
  • Updated 4 months ago
  • Answered
Hi All

I am using Reckon Accounts Hosted and am importing the transactions from our bank data and would like to know how I can match the deposits from our customers as payments to the invoices that have been previously created by me and sent to them?

Thanks in advance!
Photo of Katie Dukes

Katie Dukes

  • 90 Points 75 badge 2x thumb

Posted 3 years ago

  • 2
Photo of John G

John G, Information Support Analyst

  • 27,530 Points 20k badge 2x thumb
Hi Katie,

Welcome to the Reckon Community.

Highlight the payment you received in the Downloaded Transactions zone
Click on Add One to Register
Select the option As a payment on a tax invoice,.....




Hope this helps.


regards,
John
Photo of Katie Dukes

Katie Dukes

  • 90 Points 75 badge 2x thumb
Hi John

Thank you for your prompt reply.

This is great, I will do this in future.  I have been clicking " using the register" for all transactions.

I have already added these payments by "using the register".  What would the best way to amend this?

Thank you very much
Katie
Photo of John G

John G, Information Support Analyst

  • 27,530 Points 20k badge 2x thumb
Hi Katie,

By using the "Using the register" option your payments have not been matched to your invoices, so all those "paid" invoices will show as unpaid, even if the balance for the Customer is 0.00.  The payment is sitting on the Customer account as a deposit and is available as a Credit Note.

So you'll need to go to Customers > Receive Payments > select a customer > select an invoice, and apply the available credit to match the two and set your invoice as officially "paid".


regards,
John
Photo of Accounts NZ

Accounts NZ

  • 588 Points 500 badge 2x thumb
Hi John, I just posted as I'm having trouble getting the screen to pop up after "Add one to register" that gives the option to select "As a payment on a tax invoice." Do you know why this might be or how I can fix it? Thanks!