Skip to main content

Understanding customer balances (Accounts Receivable)

See what each B2B customer owes you in Finaloop and how invoices, payments and adjustments change that balance, so your accounts receivable stay accurate without extra work.

Written by Emily Burrows

About

Applies to: Finaloop Accounting

Finaloop Accounting, Finaloop's real-time bookkeeping and accounting service, automatically tracks what each B2B and wholesale customer owes you throughout the entire accounts receivable (AR) lifecycle, and shows it in Customers → Customer balances.

Each customer has a dedicated customer ledger, a running list on the customer's Balance tab that combines invoices, payments, refunds, adjustments, and other customer-related activity into a single view. This makes it easy to understand:

  • What a customer owes

  • Why a balance exists

  • How the balance has changed over time

  • Whether invoices have been collected

As customer activity changes, Finaloop automatically keeps each customer's balance up to date.

Here's how customer balances and the Customers page work. For wider information about how B2B sales are recorded in Finaloop, see Wholesale, Retail, and Other B2B Sales.


1. What makes up a customer's balance

A customer's balance reflects every event that affects what they owe your business.

It's calculated from:

  • Invoices (increase the balance)

  • Customer payments (decrease the balance)

  • Refunds and credits (increase or decrease the balance)

  • Customer adjustments (increase or decrease the balance)

Every activity appears in the customer ledger, creating a complete audit trail of how the customer's balance was calculated.

Customer balances are recalculated whenever new activity is recorded. As a result, any of these items may affect current or historical balances, depending on the transaction date, including when:

  • An invoice is created, edited, or deleted

  • A bank transaction is classified as an invoice payment, sales deposit, or another sales-related classification for that customer

  • A refund is issued

  • A customer adjustment is added, edited, or deleted


2. Managing your B2B customer accounts in Finaloop

To view your customer balances, navigate to Customers → Customer balances. The page opens on the Sales tab; the Balance tab is next to it.

The Customers page is designed for B2B and wholesale customers and includes every customer created from:

  • Invoices created or synced into Finaloop

  • Transactions classified as an invoice payment, sales deposit, or another related sales classification with a specific customer identified

Shopify and marketplace orders and their customers are tracked on their own pages, so they don't appear here.

Use this page to:

  • Track who owes you money

  • Monitor collections

  • Analyze your receivables

  • Review customer sales history

Customers page Balance tab in Finaloop with the As of date, Total balance, Filters and Export, and a list of B2B customer balances.

① Sales and Balance tabs, ② Total balance, ③ Export.

On both tabs, you can:

  • Select a reporting period (Period on the Sales tab, an As of date on the Balance tab)

  • Open Filters to filter by Source, set a Min or Max amount, and turn on Show zero-balance customers to include customers with zero balances

  • Search for a customer and Export the list to a CSV file

Sales tab

The Sales tab shows total sales generated by each customer during the selected reporting period, whether or not they currently have an outstanding balance.

For each customer you'll see:

  • Customer: The name of the customer

  • Source: Where the sales were generated or synced from

  • Sales category: The sales category of the customer's sales

  • Average and Count: The average sale and the number of sales in the period

  • Sales: Total sales earned during the selected time period

Summary metrics at the top of the page include:

  • Total sales

  • Sales count

  • Average sale per customer

These metrics help you understand the overall health of your wholesale business.


Balance tab

The Balance tab shows all wholesale and B2B customers with open balances, and the Total balance your customers owe you as of the selected date.

For each customer, you'll see:

  • Customer: The name of the customer

  • Source: Where the invoice was generated or synced from

  • Sales category: The sales category of the customer's sales

  • Balance: Current outstanding balance


3. Individual customer pages

Select any customer from either tab to open their customer page. It has three tabs: Balance, Sales and Link invoices. Click All customers to go back to the list.

Customer details

At the top of the page you'll find:

  • Customer name

  • Shipping address

  • Billing address

  • Email

You can edit this information by selecting from the list, adding new values, or editing existing ones. The default shipping and billing addresses you choose are used to pre-populate future invoices with this customer. Changes apply everywhere in Finaloop.

If Finaloop syncs the same customer from multiple sources using slightly different names (for example, Finaloop and Finaloop Inc.), we'll automatically merge those records whenever possible to maintain a single customer history. The Merged field shows how many customer records were merged into this one.

If you have any questions or comments on the merged customers, feel free to reach out to [email protected] to adjust.


Balance tab and customer ledger

The customer's Balance tab is a log of all sales activity relating to that customer. It contains everything related to that customer's ledger, including all transactions and amounts that impact the accounts receivable balance.

A summary at the top shows how the balance adds up for the selected Period: Opening Balance + Sales - Payments - Adjustments = Ending balance.

The customer ledger provides a complete history of activity affecting the customer's balance, including:

  • Invoices

  • Customer payments

  • Refunds

  • Customer adjustments

A running balance is displayed after every activity, in the Balance column, so you can easily understand how the current balance was calculated.

A customer's Balance tab in Finaloop with the balance summary, the Add and Export buttons and the ledger with a running balance.

① Balance summary, ② Add, ③ Balance column.

You can also Export the ledger and customer statement as Rolling balance (PDF), Rolling balance (CSV) or Open invoices (PDF).


Add customer activity

Select Add to:

  • Add Invoice: Create a new invoice

  • Add Adjustment: Add a customer adjustment, such as Merchant processing fees, Selling fee, Discount, Deduction, Marketing, FX commission, Chargebacks or Slotting fees

A customer adjustment updates the customer's overall balance and isn't tied to a specific invoice. To apply a deduction or fee to one invoice, add it when you link that invoice to its payment.


Sales tab

The customer's Sales tab displays all sales generated by that customer during the selected reporting period, with summary metrics: Total sales, Number of sales and Average sales value.


Link invoices tab

The Link invoices tab lists this customer's invoices and payments so you can link them to each other.


4. How customer payments affect the balance

Transactions classified as an invoice payment, sales deposit, or another related sales classification for that customer automatically reduce the customer's outstanding balance rather than creating additional revenue. This ensures customer balances remain accurate and prevents the same sale from being recognized twice.

There is one exception: if a customer pays more than they've been invoiced, Finaloop automatically adjusts your records to maintain a valid customer balance by increasing your sales amount for the excess payment to prevent a negative balance.

This way, even if you forget to add an invoice, your sales are properly accounted for. We call this an AR adjustment. If the missing invoice is added later, Finaloop automatically updates the AR adjustment to keep both your customer balance and revenue accurate.


5. Linking invoices and payments

Linking invoices and payments is recommended, but not required to keep your books current.

Finaloop automatically maintains accurate customer balances even if payments aren't linked to specific invoices. Linking invoices and payments also gives you a more complete accounts receivable history and improves:

  • Accounts receivable aging reports

  • Collections tracking

  • Payment visibility

  • Auditability

Keep in mind that your AR aging report is based on your open and past due invoices. This means that if you have invoices that aren't linked to payments, these invoices will still show as open, and your AR aging report won't show an accurate picture of your open receivables.

You can link invoices and payments from the invoice, from the transaction, or from the customer's Link invoices tab. For detailed instructions, see Managing B2B and wholesale invoices in Finaloop.


6. How customer balances affect your financial statements

Accrual basis

For accrual-basis companies, revenue is recognized when an invoice is issued.

At that point:

  • Revenue is recorded on your Profit & Loss statement.

  • The amount owed is recorded in Accounts Receivable on your Balance Sheet.

When a transaction is classified as a customer payment, it reduces Accounts Receivable. It doesn't create additional revenue because the sale has already been recognized.

If a customer temporarily pays more than they've been invoiced, we'll automatically adjust your records to maintain a valid customer balance by adding an AR adjustment, so the balance never goes negative. If the missing invoice is added later, the AR adjustment is updated automatically.


Cash basis

Cash-basis companies can also use the Customers page and customer ledger to monitor customer accounts. Customer balances don't affect the Balance Sheet under cash-basis accounting, but they still provide complete visibility into customer receivables and payment history. Each customer page shows a Cash-basis accounting note as a reminder.


7. If a customer balance doesn't look right

Customer balances are calculated automatically based on invoices, payments, refunds, and customer adjustments. If a balance looks too high or too low, it's usually because some customer activity is missing or incomplete.

The balance is lower than expected

A lower-than-expected balance usually means one or more invoices are missing.

For example, if a customer payment was recorded but the related invoice hasn't been created yet, the customer's balance will be lower than expected.

To fix this:

  1. Review the customer's invoices.

  2. Create or sync any missing invoices.

Once the invoice is added, Finaloop automatically recalculates the customer's balance.


The balance is higher because an invoice is no longer collectible

If an invoice was written off or is no longer expected to be collected but wasn't marked as uncollectible, it remains open and continues increasing the customer's balance. To fix this, open the invoice and, in Actions, choose Close uncollected balance to record the unpaid amount as bad debt. If the write-off isn't tied to one invoice, add the appropriate customer adjustment to reduce or remove the outstanding balance.


The balance is higher because an invoice was only partially paid or settled

Sometimes an invoice has been partially paid or settled, but the remaining balance was never adjusted. This leaves the invoice open for more than the customer actually owes. To fix this, add the missing customer adjustment to close the remaining balance.


The balance is higher because customer payments are missing or linked incorrectly

A payment may not yet appear in the customer's balance because it's waiting for your input, or linked to the wrong customer. To fix this:

  1. Review transactions waiting for your input and classify any customer payments.

  2. Verify that customer payments are linked to the correct customer.

Once corrected, the customer's balance updates automatically.

Still not seeing the expected balance? Open the customer's Balance tab to review every invoice, payment, refund, and adjustment affecting the balance. Because balances are recalculated continuously, correcting missing or incorrect activity automatically updates both current and historical balances where applicable.


8. Frequently asked questions

What affects a customer's balance?

Invoices, customer payments, refunds, customer adjustments, and other customer-related accounts receivable activity.


What happens if I add or change customer activity later?

Finaloop automatically updates the customer's balance to reflect the new information. This includes historical balances when the activity relates to an earlier date.


Do I still need to link invoices and payments?

It's not required, because balances update automatically, but linking is recommended for accurate collections tracking and aging reports.


Does this apply to cash-basis accounting?

Yes. Cash-basis users can still use the Customers page and each customer's ledger for full visibility into customer activity, even though it won't impact their financials. Customer balances are displayed using accrual-based accounts receivable activity.


Related articles


Need help?

If you have any questions about a customer balance, contact us at [email protected].

Did this answer your question?