How to handle a partial payment when creating an invoice in QBO?

Case: A customer bought $105.00 worth of product and paid $80.00 in cash. You need to send an invoice to the customer for the balance. How would you handle this in QBO?

First, create a new invoice using product/service item code for $105.00. Use deposit field to post $80.00 as the prepayment on that invoice. Deposit field is located right below the total. Now, the invoice will show $25 balance due.

If you do not see “DEPOSIT” field on your invoice, go to “Company Gear” settings to enable deposit field: Gear icon (upper right corner) > Settings > Company Settings > Sales > Deposit > ON > save. See screenshot below for reference.

Click on the screenshots below to enlarge them
enable deposit setting

Once you enter deposit amount, your invoice screen will expand to show the following three fields added to the invoice form. Fill out the information appropriately:

a) Payment method
b) Reference no.
c) Deposit to

You will need to select “Deposit to” field depending on your situation. If you are depositing this deposit (prepayment) to the bank along with other payments as a batch deposit, then you should select Undeposited Funds Account. On the other hand, if you are depositing just $80.00 as a single deposit to the bank, you should select the appropriate bank account.

deposit field on invoice

The snapshot below shows what accounts are affected by this transaction:
deposit journal report
1. Accounts Receivable: $25
2. Sales Income: $105
3. Undeposited Funds or Bank Account: $80

 

#QuickBooks Online

 

#QuickBooks Online #QBO – How to handle zero balances in accounts receivable aging

You have two ways to handle this issue in QBO:

  • Manual Setting
  • Automatic Setting (auto-mode)

You will need to select the one which is right for your business situation. When you create a new company file in QBO, normally this auto-mode is already ON as a default setting.

1zero ar aging

Manual method is commonly used when you have several customers open invoices and need to apply issued credit and received payment against a specific invoice. The credit memo may directly be related to certain specific project or a product return.
For example, you issued several product invoices to a customer. They returned one product and you had to issue a credit memo. They paid that invoice and also deducted for product return. For your business, you want to make sure, transactions (payment and credit) for that invoice is handled correctly. You would want to manually select that invoice; enter receive payment; apply credit and clear that invoice in A/R Aging.

To clear zero balance in A/R Aging:
From the home page screen > left navigation bar > customers > customer page > go to customer invoice > select “Receive Payment” under “Action” column
It will take you to “Receive Payment” screen. “Amount Received” should show zero because clearing “outstanding” and “credit” are for the same amount. Choose Save and Close. It should clear (disappear) zero balance in A/R Aging. Now, on customer page, status should indicate paid (instead of partial) and closed (instead of unapplied).

Click on the screenshots below to enlarge them
2customer page

3clear ar

4clear customer page status

Automatic method (default setting in QBO)
You can also choose “automatically apply credit” setting in QBO. By turning this setting ON, it will automatically apply credits to the next invoice you create for the same customer. General service-based companies (or non-project oriented companies) prefer turn on this setting. They do not deal with product returns. Invoices they issue are not sensitive to any specific project.

To turn on this automatic setting in QBO:
From the home page screen > company gear (upper right corner) > settings > company settings > advanced > automation > Automatically apply credits ON > save

5automatically apply credit setting

Once this automation setting is on, it is automatically take care of payment and credit. You will not see zero balances in Accounts Receivable Aging.


[table id=13 /]