Matching bank transactions to old invoices
I have a client that has paid off some quite overdue invoices. However, after the update, I can no longer match the bank transaction to invoices more than 18 months old. I have tried changing the dat...
Forum Discussion
Hi Kookamaluka,
Thanks for reaching out and welcome to the Community Forum.
I understand how important that all transactions in the bank transactions window match transactions in the system. If the system does not let us match the invoice from the bank transaction window, I would recommend manually recording the payment transactions inside the invoice window first and then matching it to the bank feeds. Generally, if the amount and the dates are correct on payment of these transactions, the system would show these as possible matches.
Let us know if you require any further assistance with this/ We're happy to help.
Cheers,
Genreve
Hi Genreve_S ,
Thank you for your reply. This particular client has been paying off for quite some time, and everything was visible and matching perfectly well prior to this update. Since the update, however, there have been a lot of bizarre changes and information missing from several areas, not just this for this client.
If there is some other way to change and access the older dates, other than the obvious ways we've always been able to use in the past, I would be grateful for any insight.
So I've found this, and it appears that "All Transactions" doesn't mean all transactions, it only means ones from the last 365 days. I really wish they wouldn't make things more difficult for us trying to use the platform. Might be time to switch back to Xero.
Hi Kookamaluka,
Thanks for your response and the screenshot you've provided.
If we record the payments for the invoice manually, these transactions would be recorded depending on the date you set it up. We can make sure that the payment is recorded on the same date as bank feed transactions. This would make the bank feed transactions show as a possible match since the date and amount are the same.
Also, I would recommend doing a future date reconciliation by following these steps. (This would make sure that there are no hidden transactions)
- Go to the Banking tab.
- Reconcile Accounts.
- Choose the bank account.
- Input the statement date 31/12/9998.
- Mark all transactions check.
- Copy the calculated closing balance to the closing bank statement balance.
- Click reconcile.
- Undo reconciliation.
Let us know if you need any further assistance with this. We're happy to help.
Cheers,
Genreve
Hi Genreve_S
Thanks very much for trying to help, your efforts are appreciated.
There weren't any hidden transactions, the system has just changed things in an annoying way. I have done the whole lot manually now. Quite frustrating since everything was working great for our business before this update to the system.
Again, thank you for your efforts.
