cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover the updated GST rates in QuickBooks Online Singapore Find out more

Reply to message

View discussion in a popup

Replying to:
JamesDuanT
Moderator

Reply to message

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