Skip to content
Bitta Apps

Bitta Collections reference

Report list

All 41 Bitta Collections reports by role center menu group, with what each prints, its request page options and layouts, plus the two analysis queries.

updated: applies-to: 1.2.0.0

This page lists the 41 reports and 2 analysis queries in Bitta Collections, with what each prints, its options and its layouts.

Applies to: Bitta Collections 1.2 on Business Central online, version 28 or later.

Find a report

Every report can be found with the search in Business Central. On the Collections and Credit role center, choose Reports and then one of nine groups. All 41 reports are in that menu. The menu name is sometimes shorter than the report name; both are given below, as "report name (menu name)".

Most reports have an RDLC layout, which is the default, and an Excel layout. Customer documents have a Word layout instead of Excel. To use another layout, choose it in Report Layouts in Business Central. Letters print on US Letter paper, with the customer address placed for a #10 window envelope.

Currency

Most reports print in local currency (LCY). Some print the currency of the record instead:

  • Short Payments and Deductions and Cash Application Register: the currency of the payment.
  • Remittance Inbox Log: the currency of each remittance.
  • Agency Placement Summary: the currency of each placed entry. Agency Recoveries: the gross recovered in its own currency, and the gross, commission and net in local currency.
  • Promises to Pay, Open Disputes, Dispute Analysis and Payment Plan Status: the currency code of each promise, dispute or plan, with the amount in local currency.
  • Follow-ups Due: the currency code of each amount.
  • Mail Register: the estimated cost in US dollars.
  • The customer documents: the currency of the invoices. The statement and the letter total each currency apart.

The Collector option

Most request pages have a Collector option. It selects the customers assigned to that collector. For the default collector, it also selects customers that have no collector. Leave it empty for all collectors.

Reports count a customer under the customer's current collector, not the collector at the time of the activity or payment.

Collector's Day

Report What it prints Options Layouts
Collector Call List Each collector's ranked work items for the day: score reasons, next action, contact, phone, email, balance, overdue and last contact Work Date, Collector RDLC (a page per collector), Excel
Customer Collection Review One page per customer before a call: balance and aging, credit limit, hold, risk, sequence, open items, promises, disputes and last activities As of, Collector, Last Activities, Show Customers Without Balance RDLC, Word
Collection Activities The activities of a period by collector and date, with notes Starting Date, Ending Date, Collector RDLC, Excel
Follow-ups Due Next actions, open promises and disputes due by a date, by collector Due by, Collector RDLC

Receivables and Aging

Report What it prints Options Layouts
Collections Aging by Collector (Aging by Collector) Aging in local currency per customer, by collector: Not Due, 1-30, 31-60, 61-90 and over 90 days Aged as of, Collector RDLC, Excel
Overdue Invoices with Collection Status Each overdue invoice with days late, amounts, dispute, promise, hold, last contact and last dunning step Overdue as of, Collector RDLC, Excel
Top Overdue Customers Customers ranked by overdue balance, with the over-90 part and each one's share of the total Overdue as of, Number of Customers, Collector RDLC
DSO and Collection Effectiveness A monthly trend of receivables, credit sales, cash, current and overdue, % overdue, DSO, best possible DSO, average days delinquent and the collection effectiveness index Ending Date, Number of Months, Collector RDLC, Excel
Allowance for Doubtful Accounts A bad-debt allowance per aging bucket and customer, plus write-off candidates: over 120 days overdue, a broken promise in the last 12 months, or an old dispute Aged as of, Collector, Write-off Candidates Only, Old Dispute Days, a percent per bucket RDLC, Excel
Collections Executive Summary A one-page monthly pack of key figures against the month before Starting Date, Ending Date, Collector RDLC
Collector Portfolio Each collector's customers with balance, overdue, open items, promises, disputes, hold, last contact and workload As of, Show Customers Without Balance RDLC, Excel
Customer Payment Behavior Per customer: invoices paid, average terms, days to pay, days late, % late, trend and broken promises Starting Date, Ending Date, Collector RDLC, Excel
Cash Forecast Expected cash per week or month, by collector and customer: amounts expected from payment history, promised amounts and plan installments, with early and late cases. Disputed amounts are shown apart As of, Period Length (Week or Month), Number of Periods, Collector RDLC, Excel

The bucket percents of Allowance for Doubtful Accounts are Not Due %, 1-30 Days %, 31-60 Days %, 61-90 Days % and Over 90 Days %. Default Percents sets them to 1, 5, 15, 40 and 75.

This group also has the query Open Receivables Analysis. See Analysis queries.

Promises and Disputes

Report What it prints Options Layouts
Collections Promises to Pay (Promises to Pay) Promises by date and collector, with amount received, status and days late Collector, Include Closed Promises RDLC, Excel
Collections Promise Performance (Promise Performance) Kept, partly kept and broken promises closed in a period, and the kept rate Starting Date, Ending Date, Collector RDLC, Excel
Collections Open Disputes (Open Disputes) Open disputes by reason, age and owner, with amounts Owner RDLC, Excel
Collections Dispute Analysis (Dispute Analysis) Disputes resolved in a period by reason, with days to resolve and the resolution Starting Date, Ending Date, Owner RDLC, Excel
Payment Plan Status Plans by status: next due date and amount, amount received, kept and broken installments Collector, Include Completed and Canceled Plans RDLC, Excel
Payment Plan Agreement The written agreement for one plan: parties, covered invoices, installment schedule, terms, payment instructions and signature lines Filters only (plan number, customer, status). Usually run with Print Agreement on the Payment Plan card or the Payment Plans list. Send Agreement on the card attaches it as a PDF Word (default), RDLC

Dunning and Communication

Report What it prints Options Layouts
Collections Dunning History (Dunning History) Every step that ran: channel, outcome (done, task created, skipped or failed), reason and reminder Starting Date, Ending Date, Collector RDLC, Excel
Collections Dunning Proposal (Dunning Proposal) A dry run of what the next run would do and why. It changes nothing Collector, Show Entries Without a Step RDLC
Collections Email Log (Collection Email Log) Emails by template and status (queued, sent or failed), with customer, subject and recipients Starting Date, Ending Date, Collector RDLC, Excel
Collections Sequence Listing (Sequence Listing) Each sequence with its status, customers and steps, for auditors Filters only RDLC
Agency Placement Summary The placement packet cover: creditor, debtor, and each placed entry with original amount, payments and credits, and open amount Filters only (placement number, agency, customer, status) RDLC, Excel
Agency Recoveries Recoveries by agency: gross, commission, net and recovery rate Starting Date, Ending Date RDLC, Excel
Mail Register The letters of a period: status, test or live, pages, class, estimated cost in USD, tracking and returns Starting Date, Ending Date, Collector RDLC, Excel

Credit Control

Report What it prints Options Layouts
Collections Customers on Credit Hold (Customers on Credit Hold) Customers on hold now: reason, since when, days, release date, overdue, balance and blocked orders Collector RDLC, Excel
Collections Credit Hold Audit (Credit Hold Audit) Holds placed and released in a period: reason, rule or user, and duration Starting Date, Ending Date, Collector RDLC, Excel
Collections Credit Limit Utilization (Credit Limit Utilization) Balance plus open sales against the credit limit, and the percent used Collector, Over Limit Only RDLC, Excel

Cash Application

Report What it prints Options Layouts
Unapplied Cash Payments and credit memos not fully applied, aged by days since posting: 0-30, 31-60, 61-90 and over 90 Aged as of, Collector RDLC, Excel
Cash Application Register Match suggestions accepted or rejected: method, confidence, rule or AI, who and when. Amounts in the payment's currency Starting Date, Ending Date, Collector RDLC, Excel
Short Payments and Deductions Invoices that accepted matches short-paid, the amount left, the dispute opened and its outcome. Amounts in the payment's currency Starting Date, Ending Date, Collector RDLC, Excel
Cash Collected Cash per customer in the period against the prior period, with the change and change % Starting Date, Ending Date, Collector RDLC, Excel
Remittance Inbox Log Remittances received: source, sender, customer, status, total in the remittance's currency, and matched payment Starting Date, Ending Date, Collector RDLC, Excel

This group also has the query Cash Received Analysis. See Analysis queries.

Team Performance

Report What it prints Options Layouts
Collections Collector Performance (Collector Performance) Per collector: customers, balance, overdue, DSO, cash, promises, kept rate, activities, disputes and holds Starting Date, Ending Date RDLC, Excel
Collection Results (Before and After) Two periods side by side: DSO, CEI, overdue share, average days late, invoices paid late, promise kept rate, match suggestions accepted, payments matched by a suggestion and collector actions, each with the change and the method Before: Starting Date and Ending Date, After: Starting Date and Ending Date, Collector RDLC, Excel

The Excel layout of Collector Performance also shows partly kept promises.

Setup and Control

Report What it prints Options Layouts
Collections Setup Check Every setup gap that stops dunning, emails or holds, each with how to fix it, plus the license status Show Information RDLC, Excel

Customer Documents

Report What it prints Options Layouts
Customer Statement (Bitta) An open-item statement with aging per currency, payment instructions, Pay online links when they are on, and a tear-off remittance slip Statement Date, Collector, Print Customers Without Open Items, Show Full Bank Account No. RDLC, Word, Mail
Collection Letter A letter per customer with overdue invoices, totals per currency, payment instructions, Pay online links and the collector's signature Letter Date, Tone (Friendly, Firm or Final), Collector, Show Full Bank Account No. RDLC, Word, Mail
Promise to Pay Confirmation Confirms the promised amount, date, payment method and invoices of one promise Filters only (promise number, customer, status). Usually run with Print Confirmation on the promise RDLC, Word
Dispute Acknowledgment Confirms receipt of a dispute: the disputed invoice and amount, the reason and next steps Filters only (dispute number, customer, status). Usually run with Print Acknowledgment on the dispute RDLC, Word

The statement and the letter show only the last 4 characters of your bank account number, unless you turn on Show Full Bank Account No.

The Mail layouts of the statement and the letter are used for letters by post. Bitta Collections chooses them for you; they have no Pay online links.

To use Customer Statement (Bitta) instead of the standard statement (report 1316), search for the sales report selections in Business Central, choose the usage Customer Statement and select report Customer Statement (Bitta).

Analysis queries

Both queries can be found with the search in Business Central and opened in Excel or in analysis mode.

Query Menu name What it shows
Collections Open Receivables Open Receivables Analysis (Receivables and Aging) Open customer ledger entries with their collector and due date
Collections Cash Received Cash Received Analysis (Cash Application) Customer payments by posting date, with the collector

Next step

Ready to try Bitta Collections?