ExcelFlux
← Import and export

Customer Collections and Open Accounts

Reconcile invoices, receipts and offsets by customer, and track balances, limits and overdue amounts.

Premium workbook preview · Member downloads are not yet available

Results from the sample workbook

Net balance
223,680
Limit excess
18,680
Overdue balance
24,360

Who can use it, and for what?

Collections, credit control and B2B trade

Compare open exposure with the assigned limit before offering more credit.

A worked example from the workbook

K-001 has a balance of 223,680 against a 205,000 limit. The excess is 18,680, with 24,360 overdue. Read the two signals separately.

Worksheet from the completed Excel sample
View from the Excel workbook. Open the image to enlarge it.
MeasureSample result
Net balance223,680
Limit excess18,680
Overdue balance24,360

How do you start with your own data?

  1. Set opening debt, credit limit, aging target and risk buffer by customer.
  2. Log invoices, receipts, offsets and overdue amounts by customer code and date.
  3. Set the report start, end and scenario on Ayarlar. Both boundary dates are included.
  4. Review per-record calculations on Analiz and totals and selected cards such as K-001 on Panel. Resolve unmatched codes, missing dates and duplicate records on Kontrol.

Test a different scenario

On Ayarlar, lower B9 from 1 to 0.50. K-001’s balance stays at 223,680 while the follow-up threshold drops to 16,776. The amount prioritised for follow-up rises from zero to 24,360. Keep K-001 selected on Panel and compare the result. Restore the original input when you finish.

Hücre adresleri ve formüller için Türkçe kılavuzu aç