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 |
Related pages
- How to read the key figures on the role center: Reports and KPIs.
- Who can run the reports: Permission sets. Running reports needs no license seat.