cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
LeedsCS
Level 1

Matching payments in bank feed to transaction from old invoicing system

Hey,

 

I work for a community centre in Leeds and we've recently moved to using QBO from an old spreadsheet system. I wanted to ask how to match/add payments in our bank feed that relate to money received through our old invoice system.

 

Whilst the payments show up in the bank feed there aren't corresponding invoices to match them to, as they were produced off our old system. My idea is that I could just post to the debtors account (and then...)? Or alternatively post straight into the correct income account, and attach the old invoice as an attachment. The other alternative could be to generate new invoices within QBO for these transactions to match them to, without sending them out to customers (i.e. for our own records). 

 

A solution that saves lots of fiddling (got 100s to go through) would be preferable! Thanks in advance :)

 

Josh L

Solved
Best answer October 18, 2019

Accepted Solutions
Jen_D
Moderator

Matching payments in bank feed to transaction from old invoicing system

Hi there, @LeedsCS,

 

When trying to download bank transactions, the system considers it a match if the amount of the payment is the same with what's in QuickBooks, and the date is within 90 days.

 

Please note that you can't perform a match, if the are no corresponding transactions entered in QuickBooks.

 

There are two ways to add the payments to the register. First, if you haven't entered any invoices or payments in QuickBooks, go to the Banking menu, and select the Add option to automatically create an entry in the register. I've included a screenshot to serve as a visual reference:

 

 

Secondly, if you opt to enter the invoices manually, you can use the Find other records option then locate the payment to match. Perform the steps below:

 

  1. Go to the Banking menu.
  2. In the For Review tab, locate and click the payment to match.
  3. Click the Match radio button and hit Find other records.
  4. In the Match transactions page, locate the invoice you'd like to match the payment.
  5. Click Save.

 

Here's an article to guide you with the process: Add and match downloaded bank transactions [Video]

 

Let me know if you have other questions or needing further assistance with the steps. I'll be here to help at any time. Have a great day!

View solution in original post

1 REPLY 1
Jen_D
Moderator

Matching payments in bank feed to transaction from old invoicing system

Hi there, @LeedsCS,

 

When trying to download bank transactions, the system considers it a match if the amount of the payment is the same with what's in QuickBooks, and the date is within 90 days.

 

Please note that you can't perform a match, if the are no corresponding transactions entered in QuickBooks.

 

There are two ways to add the payments to the register. First, if you haven't entered any invoices or payments in QuickBooks, go to the Banking menu, and select the Add option to automatically create an entry in the register. I've included a screenshot to serve as a visual reference:

 

 

Secondly, if you opt to enter the invoices manually, you can use the Find other records option then locate the payment to match. Perform the steps below:

 

  1. Go to the Banking menu.
  2. In the For Review tab, locate and click the payment to match.
  3. Click the Match radio button and hit Find other records.
  4. In the Match transactions page, locate the invoice you'd like to match the payment.
  5. Click Save.

 

Here's an article to guide you with the process: Add and match downloaded bank transactions [Video]

 

Let me know if you have other questions or needing further assistance with the steps. I'll be here to help at any time. Have a great day!

Need to get in touch?

Contact us