Quickbooky

Accounting News

Chart of Accounts

QuickBooks Online Users Group Payables and Receivables Without Extra Accounts

QuickBooks Online users who want grouped receivables or payables rely on parent customers and location tracking rather than extra ledger accounts.

COMMUNITY ISSUESQUICKBOOKY

A familiar request keeps surfacing among QuickBooks Online users: divide open receivables or payables into groups, so balance reports can show totals per program, property, or department. The software answers that request differently than many expect. It expects a single Accounts Receivable account and a single Accounts Payable account, and the grouping has to happen somewhere else in your books.

The question tends to arrive alongside a conversion or a reorganization, when someone wants an old grouping back. Two workarounds cover the ground, and we walk through both below.

One receivables account and one payables account, by design

Every company in QuickBooks Online starts with exactly one Accounts Receivable account and one Accounts Payable account. These are the defaults created during initial setup, or the accounts you selected during a conversion from another system. The standing guidance is to keep that pair intact. Splitting receivables across several accounts fragments reporting, and each extra account adds reconciliation work. Users who managed separate accounts in other packages often go looking for the same option here.

Can parent customers group your open receivables?

Yes, and this is the route that settles most of these discussions. You create one parent customer for each grouping, then attach your existing customers to it as sub-customers. The invoices themselves do not change. The hierarchy does the organizing, and reports can roll balances up to the parent. On reports that list customers, sub-customers indent beneath their parent, so the grouping is visible at a glance.

The setup takes a few minutes. Create a new customer, and in the company name field enter a label that identifies the group. Borrowing the name of a receivable account from your chart of accounts works well as that label, though nothing links the two. Save the record. Then open an existing customer, choose the edit option, tick the checkbox that marks it a sub-customer, and select the new parent from the dropdown. Repeat for each customer in the group.

Menu labels shift between releases, so treat any single path as approximate. In current builds, the customer list sits inside the Customer Hub, reached from the All apps area. On older screens the same edit controls appear on the customer record itself. Either way, the checkbox and the parent dropdown are the parts that matter.

Does location tracking cover payables?

Location tracking does, and it works on the receivables side as well. Locations are tags attached to individual transactions, on both the customer and vendor side. You then filter your balance reports by tag, which yields grouped totals without adding a single account. Vendors have no matching hierarchy feature, so the tag route carries the payables side on its own.

One constraint matters here. Location tracking ships with Plus and Advanced subscriptions and is not offered on the lower tiers. If your plan sits below those, the parent customer route above remains open to you.

After turning locations on, confirm every invoice, bill, and other transaction carries one. The Customer Balance Detail and Vendor Balance Detail reports include a location column for exactly this check. Where a row is blank, open that transaction straight from the report and add the missing tag. Then customize the report, open the filter section, choose a single location, and run it. The output is a balance view scoped to one group.

What if you already created several of these accounts?

Some users reach this question after adding extra receivable or payable accounts and finding them awkward to maintain. The cleanup that accompanies these workarounds is a merge. Rename the account you want to retire so its name exactly matches the account you are keeping, then confirm the merge when the program offers it. The history combines under the surviving account. Grouping then moves to parent customers or location tags, where the software actually supports it.

A design choice, not a bug

None of this is breakage. QuickBooks Online treats receivables and payables as control accounts, single buckets that the customer and vendor ledgers feed into. Grouping lives below that level, in the customer hierarchy or in transaction tags, and the reports follow those structures. Users who accept the model stop wrestling with the chart of accounts. Those with a genuine need for separate ledgers, such as distinct legal entities, usually do better with separate companies than with parallel accounts.

← Back to Community Issues