Quickbooks Tips: Offsetting Payables Against Receivables - CFO Source
Maximizing Profits, Minimizing Taxes,
And Finding Capital For Our Clients

Quickbooks Tips: Offsetting Payables Against Receivables

QuickBooks is the ideal solution for organizing, managing, and analyzing your business’s finances. Understanding how offset payables against receivables in business accounting can be overwhelming if you aren’t familiar with this software, but The CFO Source is a valuable resource that’s here to help.

If your business has both payables and receivables due to and from the same company, both accounts must be offset and cleared appropriately in Quickbooks. In many of these situations, both companies may agree upon a deal that nets the payables and receivables, which results in one net payment either made or received by your business. When this occurs, it’s essential to record the payment and clear the two accounts to create a balance and ensure your books are correct.

Let’s look at an example situation to better understand how this is executed in Quickbooks:

Establishing the AP, AR, and Net Amounts

Your business, Company A, currently has 5 invoices payable to Company B for products purchased. The invoice amounts are as follows:

  • Invoice #1: $250
  • Invoice #2: $750
  • Invoice #3: $50
  • Invoice #4: $350
  • Invoice #5: $100

Your total amount payable is $1,500. At the same time, Company B owes you payment for one outstanding invoice for services rendered by your company.

Your current amount receivable amount from Company B is $1,000. Rather than having both Company A and Company B make their respective payments, you have come come to an agreement that your company will simply pay the net balance of the two. Therefore:

$1,500 (AP – Accounts Payable) – $1,000 (AR – Accounts Receivable) = $500 (Net)

Offsetting the Accounts in Quickbooks

Now that you have the established net amount due, you can record and offset the accounts in Quickbooks by following these steps:

Step 1: In your Chart of Accounts, create an account titled AP/AR Offset and label it under the ‘Expense‘ account type.

Step 2: Set up a Service item code titled AP/AR Offset, and have the item code account assigned to the AP/AR Offset account you set up in Step 1.

Step 3: Use a credit memo to zero out whichever is less, the AP or AR balance that you want to net. In the example we provided above, this would be the accounts receivable (AR) that your business, Company A, has due from Company B: $1,000. To do this, select Customer, then Create Credit Memos/Refunds

Step 4: Click Save and Close and you will see an Available Credit message. When asked what you would like to do with the credit, select Apply to an invoice and click OK.

Step 5: On the Apply Credit Invoices screen, select the invoice to which to apply the credit memo you just created. This will be Company B’s invoice of $1,000. Once selected and confirmed, the AR balance will be zeroed out and accounts payable (AP) can be addressed.

Step 6: Generate a credit memo of $1,000 to Company B and charge it to the AP/AR Offset account. Once generated, you will be ready to record and create your payment of the Net balance due to Company B.

Step 7: Select Vendors, then Pay Bills. Find Company B in the vendor list and select each of the 5 open invoices listed in the example above. As you select each invoice, you’ll see a Bills Paid By Credits message that informs you that the invoices are being paid from the available credit. Select OK. Once the credit has been exhausted, you will see the amount to pay as $500.

Once you have confirmed that the Credits Used and Amount to Pay – $1,000 and $500, respectively – are correct, you can print the check as normal.

Get Professional QuickBooks Help for Your Business

QuickBooks provides the accounting software necessary for businesses and and we are here to guide you in using it to best manage your business finances. For the expert guidance your business needs, look to The CFO Source. We can help you make the profitability process simpler and give you the peace of mind that your business’s finances are managed with expert care. Call or contact us today to get started.

What Our Clients Say...

"We struggled for several years with high turnover in our bookkeeper position, which resulted in missed billings and duplicate payments. Craig Kershaw was able to locate a high caliber person who quickly took over the accounting and is now helping to expand the business into new markets. I no longer worry about whether my accounting is being done properly."

-Bryant Brambeck, Owner, Liberty Emblem Company

Does Your Company Need
CFO or Accounting Support?
REQUEST A
COMPLIMENTARY
ANALYSIS
  • This field is for validation purposes and should be left unchanged.

arrow Click to View the Areas That We Serve arrow

Regions Served

  • Frederick County: Frederick (21701, 20702, 21703, 21709), New Market (21774) , Mount Airy (21771), Urbana (21704), Ijamsville (21754), Walkersville (21793), Libertytown (21762), Damascus (20872), and more.

    Howard County: Clarksville (21029), Columbia (21044), Cooksville (21723), Dorsey (21075), Elkridge (21075), Ellicott City (21043), Fulton (20759), Glenelg (21737), Glenwood (21738), Granite (21163), Hanover (21076), Highland (20777), Jessup (20794), Lisbon (21765), Marriottsville (21104), North Laurel (20723), West Friendship (21794), Woodbine (21797), Woodstock (21163), and more.

    Montgomery County: Olney (20832), Damascus (20872), Laytonsville (20882), Silver Spring (20910), Clarksburg (20871), Gaithersburg (20878), Germantown (20876), Bethesda (20816), Chevy Chase (20815), and more.

    Baltimore County: Arbutus (21227), Catonsville (21228, 21250), Cockeysville (21030, 21031, 21065), Dundalk (21222), Edgemere (21219), Essex (21221), Garrison (21055), Lansdowne (21227), Lochearn (21207), Lutherville (21093), Middle River (21220), Milford Mill (21244), Overlea (21236), Owings Mills (21117), Parkville (21234), Park Heights (21215), Pikesville (21208), Randallstown (21133), Reisterstown (21136), Rosedale (21237), Timonium (21093), Towson (21204), White Marsh (21162), Woodlawn (21207), and more.

    Carroll County: Eldersburg (21784), Finksburg (21048), Hampstead (21074), Manchester (21102), Marriottsville (21104), Taneytown (21787), Union Bridge (21791), Westminster (21157, 21158), Mount Airy (21771), New Windsor (21776), Sykesville (21784), Woodbine (21797), Taneytown (21787), and more.

  • Washington, DC and Northern Virginia

cbs radio

AICPA MACPA FEI

Connect

facebook twitter linked in

Contact CFO Source

5515 Hudson Drive
Sykesville, MD 21784
phone icon 443-487-7733 | Fax: (206)415-2361
info@cfosource.net

certified advisor