EN
Bookkeeping

How Do You Choose Account Tracking Software? A Checklist for Balances, Due Dates, Risk Limits and Reconciliation

How do you choose account tracking software? A checklist for account cards, balance, payment terms, collection, risk limit, statement and reconciliation, with a hand-verified example.

Contents 12 sections
  1. What is account tracking software and how does it differ from Excel?
  2. Which features should you look for in account tracking software?
  3. How do you set up an account card and what information should you enter?
  4. How are account balance, payment terms and delays calculated?
  5. How are collections and payments recorded in the account?
  6. How is a customer risk limit set and how does it work in the software?
  7. How are statements and reconciliation handled?
  8. How should a marketplace seller set up accounts?
  9. How do you move from Excel to account tracking software?
  10. What are the most common mistakes when choosing account tracking software?
  11. How do you track accounts with NetKasam?
  12. Frequently Asked Questions About Account Tracking Software

As a business grows, the question "who owes us how much, and whom do we owe how much?" can no longer be answered from a ledger or an Excel file. An overdue invoice slips through, goods are shipped to a customer above their limit, and at month end the two sides' balances do not match. The solution is usually to use account tracking software; but in the shop window they all make the same promise, and you only see the difference at the first reconciliation or the first late collection.

This article does not explain what a current account is from scratch; for that, see the article what is a current account. Here we answer two questions: which features should you look for in the software, and once you have chosen it, how do you use it in daily work? You will find, step by step, the account card, balance and due date calculation with a hand-verified three-customer example, the risk limit, statements and reconciliation, account logic for a marketplace seller, and moving from Excel. The sample figures are only there to illustrate the method.

What is account tracking software and how does it differ from Excel?

In short: Current account tracking software records your debit-credit relationship with customers and suppliers card by card and calculates balances and due dates automatically. The difference from Excel is that invoices, collections and payments come from the same system, so the balance does not need to be updated by hand.

A current account is the account of the commercial relationship you run with a person or company; when you sell, the customer owes you, and when you collect, the debt is closed. The same card works the other way when you buy from a supplier. For details of the term, see the current account glossary page.

Excel is enough for a small customer list. The problem appears as the number of rows grows: when an invoice is cancelled, the balance formula breaks, a partial collection loses track of which invoice it belongs to, the same customer is split into two rows under two different spellings, and you prepare the statement by hand every time. Software prevents these errors at the point of data entry.

TopicExcel fileAccount tracking software
BalanceUpdated with formulas and by handUpdated instantly with every invoice and collection
Due dateSeparate column, depends on whoever checks itTracked per invoice, overdue ones are listed
CollectionAmount is entered, which invoice it belongs to gets confusedApplied to the invoice, remaining amount is visible
Statement and reconciliationPrepared by hand every timeGenerated from records and shared
Risk controlNot checked at the time of saleWarning or sales restriction when the limit is exceeded
Multiple usersConflicting edits to the same fileSimultaneous work, user trail on each record

Which features should you look for in account tracking software?

In short: When choosing account tracking software, ten features are questioned: account card fields, customer and supplier separation, due date tracking, reminders, risk limit, collection and payment methods, statement sharing, reconciliation, invoice integrity and importing from Excel. Try each one in the demo with your own data.

The table below collects questions you can put directly to the vendor or demo team and what a good answer looks like:

FeatureQuestion to askWhat does a good answer look like?
Account cardAre there fields for company name, tax number, address, contact person, payment term days and document storage?Fields can be customized; documents are attached to the card
Account typeCan the same company be both a customer and a supplier?Two-way balance and netting on a single card
Due date trackingIs the due date of each invoice tracked separately; can I list overdue ones?Due date is per invoice; overdue and upcoming are reported separately
RemindersAre balance or due date reminders sent to the customer automatically?SMS or email; template-based, bulk sending
Risk limitWhat happens when the limit is exceeded?Warning and optional sales restriction
Collection and paymentDoes it support closing with cash, bank transfer, card, cheques and promissory notes; how are partial collections handled?Each method posts to the cash account or bank; it is applied to the invoice
StatementCan I share the statement with the customer online?Generated by date range, shared by link or PDF
ReconciliationCan a reconciliation letter be sent from the system and a reply received?Bulk sending, reply status, difference record
Invoice integrityWhen I issue an e-Invoice or e-Archive invoice, is the account entry created automatically?Invoice and account are in the same system; no separate transfer needed
Data importCan I bring in my existing customer list from Excel?Template-based import and support

The single most neglected item on the list is invoice integrity. If you issue invoices in one program and keep accounts somewhere else, every transaction is entered twice and the two records eventually diverge. If invoicing, account balance and collection are in one system, the source of error disappears; for this, make sure invoice tracking and current accounts are in the same place.

How do you set up an account card and what information should you enter?

In short: An account card is the customer or supplier record that holds the company name, tax number, contact details, payment term days and risk limit. If the card's information is entered completely from the start, invoices, statements and reconciliation work without later corrections.

How the account card is filled in on day one determines the quality of every later report. The card should contain the following:

  • Identity: company name or full name, tax office and tax ID number. Whether they are an e-Invoice taxpayer ensures the correct invoice type is selected.
  • Contact: phone and email so you can send reminders and statements, and the person responsible for payments.
  • Commercial terms: default payment term days, customer-specific discount or price, preferred payment method.
  • Risk limit: the maximum open balance the customer can carry.
  • Documents: papers such as the contract, tax certificate and letter of guarantee.

Separating customers and suppliers by type instead of putting them in one list makes balances easier to read. If one card has two roles (you both buy from and sell to the same company), the net balance is the difference between the two directions. Opening two cards for the same company under two spellings is the most common data problem; making the tax number field mandatory largely prevents this.

How are account balance, payment terms and delays calculated?

In short: The account balance is found by subtracting the collections you received from the invoices you issued to the customer. The due date is calculated by adding the payment term days to the invoice date, and days overdue by subtracting the due date from the report date; for an invoice that is not yet due, the delay is zero.

FormulaFive basic calculations of account tracking
  1. Account balance = Invoices issued − returns and discounts − collections received
  2. Due date = Invoice date + payment term days
  3. Days overdue = Report date − due date (if less than zero, it is not yet due)
  4. Risk usage = Open balance ÷ risk limit × 100
  5. Weighted average delay = Σ(overdue amount × days overdue) ÷ Σ overdue amount

Amounts are taken VAT-inclusive, based on the invoice total.

Let's see the calculation with a three-customer example. The report date is October 20, 2026. The invoices and collections are as follows:

  • Yıldız Market: invoice of ₺18,000 on October 12, 30-day terms. No collection.
  • Demir Tekstil: invoice of ₺24,000 on September 1, 30-day terms. Partial collection of ₺10,000 on October 15.
  • Akın Ticaret: invoice of ₺30,000 on August 15, 45-day terms; second invoice of ₺6,000 on October 10, 30-day terms. No collection.

Due dates: Yıldız Market's invoice is October 12 + 30 days = November 11. Demir Tekstil's invoice is September 1 + 30 days = October 1; 19 days overdue as of the report date. Akın Ticaret's first invoice is August 15 + 45 days = September 29; 21 days overdue. Its second invoice is October 10 + 30 days = November 9, not yet due.

CustomerOpen balanceNot yet dueOverdueDelay
Yıldız Market18.000 ₺18.000 ₺0 ₺-
Demir Tekstil14.000 ₺0 ₺14.000 ₺19 days
Akın Ticaret36.000 ₺6.000 ₺30.000 ₺21 days
Total68.000 ₺24.000 ₺44.000 ₺avg. 20.4 days

Check: for Demir Tekstil, 24,000 − 10,000 = ₺14,000. For Akın Ticaret, 30,000 + 6,000 = ₺36,000. Total open balance 18,000 + 14,000 + 36,000 = ₺68,000; overdue 14,000 + 30,000 = ₺44,000. The weighted average delay is (14,000 × 19 + 30,000 × 21) ÷ 44,000 = 896,000 ÷ 44,000 = 20.4 days.

BreakdownBreakdown of the ₺68,000 open balance across three customers by due date status
  • Akın Ticaret, overdue₺30,00044.1%
  • Yıldız Market, not yet due₺18,00026.5%
  • Demir Tekstil, overdue₺14,00020.6%
  • Akın Ticaret, not yet due₺6,0008.8%

Prepared with sample values. Report date October 20, 2026.

Takeaways from the exampleThree customers, four critical numbers
  • ₺68,000total open balance
  • 64.7%overdue share (44,000 ÷ 68,000)
  • 20.4 daysweighted average delay
  • 120%Akın Ticaret's risk usage

What stands out in the table is this: the total balance alone is misleading. Yıldız Market's ₺18,000 is healthy, while Akın Ticaret's ₺30,000 is a problem. Software that does not split the balance by due date shows you only the size, not the risk. For details of grouping by due date (aging), see the article how to track receivables; the concept of payment term is explained separately in the glossary.

How are collections and payments recorded in the account?

In short: A collection reduces the customer's debt, and a payment reduces your debt to the supplier. In a correct record, every collection is applied to an invoice; with a partial payment, the amount remaining on the invoice is visible and due date tracking continues on the remaining amount.

It is also important to know which cash account or bank account the collection went into: cash goes to the cash register, bank transfers and credit cards to the bank, and cheques and promissory notes to the portfolio. Creating the collection record on the account side and the cash/bank side at the same time lets the cash count and the account balance verify each other. If you work with cheques and promissory notes, you need cheque and promissory note management to track due and collection dates separately.

In the Demir Tekstil example, the ₺10,000 collection on October 15 was applied to the invoice dated September 1, and the remaining ₺14,000 continued to be tracked as overdue. Had the collection not been linked to the invoice, the customer would say "I paid ₺10,000" and you would scan the statement line by line to find which invoice was closed. The same rule applies to supplier payments: knowing which purchase invoice you closed removes the risk of paying twice.

If you want to collect online from customers by credit card, look for a flow that links this to the account statement; for details, see the online collection page.

Recommended readingHow to Track Receivables? A Guide to Payment Terms, Receivables Aging, Collection Period and Risk Limit

How is a customer risk limit set and how does it work in the software?

In short: A risk limit is the amount that sets the maximum open balance a customer can carry. When the limit is exceeded, the software warns you or restricts new sales; this way new debt is not added on top of uncollected debt.

When setting the limit, you look at past payment habits, monthly sales volume and payment term days. A practical rule is to keep the limit close to your monthly sales to the customer multiplied over the payment term; however, this is not a fixed value but a starting point adjusted to the risk you can bear. Starting a new customer on a low limit and raising it based on their payment pattern is the safest route.

In our example, let the limits be: Yıldız Market ₺25,000, Demir Tekstil ₺20,000, Akın Ticaret ₺30,000. Risk usage is the ratio of the open balance to the limit:

ChartRisk limit usage: only Akın Ticaret is above the limit
  1. Yıldız Market (18,000 ÷ 25,000)72%
  2. Demir Tekstil (14,000 ÷ 20,000)70%
  3. Akın Ticaret (36,000 ÷ 30,000)120%

Prepared with sample values. Akın Ticaret's excess of ₺6,000 comes from the second invoice issued on top of the overdue debt.

The Akın Ticaret example shows why the risk limit should kick in at the time of sale: a new shipment was made on October 10 before the ₺30,000 due on September 29 was collected. Had the software checked the limit, a warning would have appeared before the second invoice was issued. Along with the limit, you need to look at the aging report and call the customer whose risk is growing; the method is explained in detail in the training how to track current accounts.

How are statements and reconciliation handled?

In short: A statement is an ordered listing of all of an account's transactions within a given date range. Reconciliation is both parties confirming the same balance as of the same date; if there is a difference, its source is found and closed.

The software generates the statement from records and lets you filter by date range, document type or balance status. A statement shared online settles your customer's "it looks different on my side" objection from day one, because both sides look at the same record. Typical causes of reconciliation differences are: an invoice the other party has not yet entered, a collection that reached the bank but was not posted to the account, a return invoice falling on a different date, and exchange rate differences. Once the cause is identified, the correcting document is entered on the same date on both sides.

Reconcile not once a year but at least every three months, and monthly for high-volume customers. For sending letters, tracking replies and handling objections, you can use the steps in the article what is account reconciliation and how is it done. The software sending the letter from the system, linking the reply to the record and showing the difference lines should be among your selection criteria.

How should a marketplace seller set up accounts?

In short: Your relationship with a marketplace is also an account relationship: your sales make the marketplace a debtor, commission, shipping and returns reduce this debt, and the payout is a collection. If you track the marketplace like an account card, you always know the pending payout.

On a marketplace, the customer pays the marketplace, not you; the marketplace deducts its charges on a set payout schedule and deposits the rest into your account. Written in account terms, total sales are your receivable, commission, service fee, shipping and return deductions are items that reduce the receivable, and the amount deposited in the bank is the collection. Until the collection arrives, the payout stays as an "open balance". The due date logic from the previous section applies here too: you know the payout date, and if there is a delay, you look for the reason.

Example: in one payout period there are ₺50,000 of sales on the marketplace. Let commission be ₺9,000, shipping deduction ₺3,500 and returns ₺2,500.

ChartFrom ₺50,000 of marketplace sales to a ₺35,000 payout
  1. Period sales₺50,000
  2. Commission−₺9,000
  3. Shipping deduction−₺3,500
  4. Returns−₺2,500
  5. Expected payout₺35,000

Prepared with sample values. Deduction items and the payout schedule vary according to the marketplace's contract.

If the amount deposited into your account differs from ₺35,000, the difference shows up in the account and is resolved by comparing it with the marketplace statement. For this approach to work, orders and invoices need to be gathered in one place; marketplace integration combines this data on one screen. To break down the deduction items on the profitability side by product, see the article how to calculate net profit on a marketplace.

How do you move from Excel to account tracking software?

In short: The move has five steps: cleaning up Excel, importing account cards, entering opening balances, recording open invoices with their due dates, and comparing the first statement with the Excel total. Do not let go of the old file until the numbers match.

Migration planMoving from Excel to account tracking software in five steps
  1. 01
    Clean up the listMerge duplicates of the same company and complete tax numbers.
  2. 02
    Import the account cardsImport the customer and supplier list using a template.
  3. 03
    Enter opening balancesRecord the balance on the migration date as a single entry for each account.
  4. 04
    Add open invoicesRecord invoices that are not yet due and overdue with their due dates.
  5. 05
    Compare the totalsMatch the software's total balance with the Excel total and with a few statements.

The biggest risk is entering the opening balance incorrectly; doing one last reconciliation in Excel before the move makes later corrections easier. If you are making a similar move on the accounting side, the checklist in the article moving from Excel to cloud accounting software can be added to this plan. Instead of moving a large list in one go, first run a trial with your twenty most active accounts.

What are the most common mistakes when choosing account tracking software?

In short: The most common mistakes are looking only at price, keeping invoices and accounts in separate places, not testing due date tracking, and letting go of the old file without testing the migration. All of these can be caught during the demo.

  1. Looking only at price. Cheap software without due date and risk reports turns out expensive at the first late collection.
  2. Separating invoices and accounts. Double entry means double errors.
  3. Not testing partial collections. Many systems are good with full payments and bad with partial ones.
  4. Thinking the risk limit is just a field. A limit that is not checked at the time of sale is useless.
  5. Leaving reminders to manual work. Collection calls become regular with the software's reminders.
  6. Opening incomplete account cards. Reminders and statements cannot be sent to a card without a phone number and email.
  7. Not comparing balances during migration. The error only surfaces at the first reconciliation.

How do you track accounts with NetKasam?

In short: In NetKasam, account tracking is part of free bookkeeping. There is no limit on the number of accounts; online statements, reminders for payments approaching or past due, balance reminders, risk settings, reconciliation letters and customer-specific discounts or campaigns are managed from the same screen.

As described on the customer and supplier account tracking page, you can import your customers with the help of Excel, attach their documents to the account card, restrict new sales for an account when the risk level you set is reached, and send a reconciliation letter with one click. Balance reminders can be sent by bulk SMS. Because invoicing is in the same system, the invoices you issue are reflected in the account; for the expense side see expense management, and for cash and bank transactions see the reports page. For bookkeeping as a whole, you can look at the bookkeeping software page.

To get started, all you need to do is open an account and import your account cards from Excel; wherever you get stuck, the user guide and support team are there for you. Current plans and the free scope are on the pricing page.

Frequently Asked Questions About Account Tracking Software

How do you choose account tracking software?

Try the criteria of account card fields, due date tracking, reminders, risk limit, collection methods, statement, reconciliation, invoice integrity and importing from Excel in a demo with your own data. Whether the balance matches your manual calculation is the most reliable test.

Can account tracking be done in Excel?

It can for a small number of accounts. As the number of invoices, returns and partial collections grows, the risk of formula errors and conflicting edits increases; at this point software ensures record integrity.

How is the account balance calculated?

In a customer account, the balance is found by subtracting returns, discounts and collections from the invoices issued. If the result is positive, the customer owes you; if negative, the customer has a credit.

How are overdue receivables tracked?

The due date of each invoice is recorded, and those past due on the report date are listed with their days overdue. A reminder is sent and the collection result is posted to the account.

What is a risk limit for?

It caps the highest open balance a customer can carry. When the limit is exceeded, a warning is shown or new sales are restricted; this way new debt is not added on top of uncollected debt.

How often should accounts be reconciled?

Year end is not enough. Reconciling at least every three months, and monthly for customers with heavy activity, lets you find differences while they are small.

Does it make sense to track marketplace payouts in an account?

Yes. Treating the marketplace like an account card, counting sales as receivables, deductions as reducing items and the payout as a collection makes the pending amount visible. The difference between the expected and the deposited payout is then questioned.

Is there a limit on the number of accounts in NetKasam?

No. In NetKasam you can create as many customers and carry out as many transactions as you like. Account tracking is part of free bookkeeping.

The right account tracking software is one that shows risk and overdue receivables as well as the balance. As a first step, try the ten questions in this article with two or three candidates, bring your three most difficult customers to the demo and compare the total with your own calculation.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeCustomer and Supplier Account Tracking

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools