United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover the updated GST rates in QuickBooks Online Singapore Find out more
userhuini
Level 3
posted
‎January 05, 2021 10:31 PM
last updated ‎January 05, 2021 10:31 PM

Any way to match the invoice from bank deposit without connect account?

 
Solved
Reply
Best answer January 06, 2021
Solved

Best Answers
JamesDuanT
Moderator
Moderator
‎January 06, 2021 01:05 AM

Any way to match the invoice from bank deposit without connect account?

Thanks for getting back to us and providing additional details of your concern, userhuini.

 

Since you've mentioned that you're recording your invoices as journal entries, you're most likely doing it like this:

  1. Click the + New button in the upper-left corner and select Journal entry.
  2. Debit the Accounts Receivable (A/R) and associating the customer name.
  3. Credit the income account.
  4. Click Save and close.

If that's you did it, you still need to go to the Receive payment window to zero out the A/R balance:

  1. Click the + New button in the upper-left corner and select Receive payment.
  2. Select the Customer and enter the other necessary details.
  3. Under the Outstanding Transactions section, mark the journal entry you've created.
  4. Make sure you select Undeposited Funds in the Deposit to field.
  5. Enter the PAYMENT amount.
  6. Click Save and close.

Note that paying the outstanding A/R balance will also zero out the OPEN BALANCE column of the A/R Aging report.

 

After creating the invoice payment, we can already create a bank deposit.

  1. Click the + New button in the upper-left corner and select Bank deposit.
  2. Select the bank account in the Account field and enter the Date.
  3. Under the Select the payments included in this deposit section, mark the payment you've made earlier.
  4. Click Save and close.

If you want to record the bank deposit in advance, you should create it this way:

  1. Click the + New button in the upper-left corner and select Bank deposit.
  2. Select the bank account in the Account field and enter the Date.
  3. Go to the Add funds to this deposit section and select the  customer name in the RECEIVED FROM column.
  4. Select Accounts Receivable (A/R) in the ACCOUNT column and enter the received amount.
  5. Click Save and close.

After that, you can create the journal entry like you always do, and link both transactions through the Receive payment window.

 

Here are some links related to the steps I've laid out earlier:

I'd recommend utilizing the Invoice function in QuickBooks Online so you won't need to create journal entries.

 

It is normal to have negative and positive amounts in the A/R aging report since those transactions are affecting the A/R account.

 

Let us know if you have additional queries regarding this matter.

View solution in original post

Reply
4 Comments 4
AlexV
QuickBooks Team
QuickBooks Team
‎January 05, 2021 11:17 PM

Any way to match the invoice from bank deposit without connect account?

There's a way to match them, userhuini.

 

You don't have to link your bank but you need a file from your financial institution that we can upload to QuickBooks Online. You can use either .QBO or .CSV file format and the maximum file size is 350 KB.

 

Please follow these steps:

  1. Go to the Banking or Transactions menu and select Upload transactions.
  2. Click Browse and then select the file you downloaded from your bank. Then select Next.
  3. In the QuickBooks account ▼ dropdown, select the account you want to upload the transactions into. Then select Next.
  4. Follow the onscreen steps to map the data. Then select Next.
  5. Tap Let's go.

If you haven't yet, you can create a new bank account. Once done,  it's time to match and categorise them. You can also check this link for more info: Manually upload transactions into QuickBooks Online.

 

The Community is always here to help you if you have other concerns. Take care!

Reply
userhuini
Level 3
‎January 05, 2021 11:24 PM

Any way to match the invoice from bank deposit without connect account?

Hello,

Thanks for your reply. However this is not what I want, we do not want to manually link the bank.

But I would like to know if there is any for feature under bank deposit to match the invoice that customer paid?

Because we use journal voucher to input that particular invoice thus I would like match it under bank deposit however even in the Aging it showed zero but it still came out with one positive and one negative.

I would like to eliminate it.

Please suggest other solutions.

Thanks a lot.

 

 

Allied.PNG

Reply
JamesDuanT
Moderator
Moderator
‎January 06, 2021 01:05 AM

Any way to match the invoice from bank deposit without connect account?

Thanks for getting back to us and providing additional details of your concern, userhuini.

 

Since you've mentioned that you're recording your invoices as journal entries, you're most likely doing it like this:

  1. Click the + New button in the upper-left corner and select Journal entry.
  2. Debit the Accounts Receivable (A/R) and associating the customer name.
  3. Credit the income account.
  4. Click Save and close.

If that's you did it, you still need to go to the Receive payment window to zero out the A/R balance:

  1. Click the + New button in the upper-left corner and select Receive payment.
  2. Select the Customer and enter the other necessary details.
  3. Under the Outstanding Transactions section, mark the journal entry you've created.
  4. Make sure you select Undeposited Funds in the Deposit to field.
  5. Enter the PAYMENT amount.
  6. Click Save and close.

Note that paying the outstanding A/R balance will also zero out the OPEN BALANCE column of the A/R Aging report.

 

After creating the invoice payment, we can already create a bank deposit.

  1. Click the + New button in the upper-left corner and select Bank deposit.
  2. Select the bank account in the Account field and enter the Date.
  3. Under the Select the payments included in this deposit section, mark the payment you've made earlier.
  4. Click Save and close.

If you want to record the bank deposit in advance, you should create it this way:

  1. Click the + New button in the upper-left corner and select Bank deposit.
  2. Select the bank account in the Account field and enter the Date.
  3. Go to the Add funds to this deposit section and select the  customer name in the RECEIVED FROM column.
  4. Select Accounts Receivable (A/R) in the ACCOUNT column and enter the received amount.
  5. Click Save and close.

After that, you can create the journal entry like you always do, and link both transactions through the Receive payment window.

 

Here are some links related to the steps I've laid out earlier:

I'd recommend utilizing the Invoice function in QuickBooks Online so you won't need to create journal entries.

 

It is normal to have negative and positive amounts in the A/R aging report since those transactions are affecting the A/R account.

 

Let us know if you have additional queries regarding this matter.

Reply
userhuini
Level 3
‎January 07, 2021 01:26 AM

Any way to match the invoice from bank deposit without connect account?

OK thanks please proceed to close this ticket then. Cheers

Reply