|
<< Click to Display Table of Contents >> Navigation: MLS 2026 Fully Integrated Accounting > Accounts Receivable > Accounts Receivable Reports |
MLS 2026 includes a variety of reports that help you review balances, track activity, monitor overdue accounts, and analyze monthly performance.
Important:
Reports are informational only. They do not change any data and can be run as often as needed.
A summary of every A/R account, including:
•Client name
•Date of last payment
•Current balance
•Amount overdue
This is your primary A/R overview report. It shows:
•Total receivables
•Who owes you money
No input required. The report reviews all accounts automatically.
A complete transaction history for one account over a selected date range:
•Client information
•Prior balances and aging
•All activity within the selected period
•Enter the account number
•Enter beginning and ending dates
This is your most important customer-facing report.
Use it when:
•A client questions a charge
•You need to verify past activity
•You want to provide a detailed record
•“I think I was charged twice”
•“I already paid that invoice”
•“Can you send me my account history?”
MLS 2026 provides a level of detail that many systems cannot—clients appreciate this clarity.
A directory of all A/R accounts:
•Name
•Address
•Phone
•Billing cycle
•Terms
•Credit limit
•No financial balances (directory only)
•Quick reference when calling clients
•Helpful during statement processing
•Useful for mailings
Many shops print this monthly and keep it in a binder.
All current activity in the transaction file:
•Account number
•Transaction date
•Invoice number
•Charge and payment amounts
•Billing cycle
A total appears at the end.
This is a key troubleshooting report.
Use it to find:
•Transactions not tied to accounts
•Missing billing cycles
•Old or unprocessed activity
All overdue accounts, including:
•Account number
•Client name
•Date of last payment
•Current balance
•Aging breakdown (Current, 30, 60, 90+)
This is your collections report.
It shows exactly:
•Who is late
•How late they are
•How much is overdue
•Run after each billing cycle
•Follow up with overdue clients
•Set Flag = HOLD for problem accounts
•Review credit limits for repeat offenders
👉 Keeping this report small is key to maintaining healthy cash flow.
All write-offs applied, including:
•Bad debt
•Courtesy adjustments
Provides a clear record of:
•Amounts removed from A/R
•Reasons for those adjustments
Receivable totals for all clients for a specific month.
•Enter the first three letters of the month (e.g., JAN, FEB, MAR)
•Supports end-of-month review
•Shows total billed and collected
•Helps verify accounting activity
Most shops run this monthly.
Generates an Excel spreadsheet of monthly totals by account.
•Supports cash-flow analysis
•Allows modeling of collection scenarios
•Provides long-term visibility into receivables
Shops that want deeper financial insight will find this report especially valuable.
•Run summary and overdue reports regularly
•Use individual account reports to resolve disputes
•Monitor overdue balances consistently
•Review monthly totals as part of closing
•Organizes each report into What / Why / How
•Makes it easy to scan and reference
•Clearly distinguishes operational vs analytical reports
•Reinforces how each report is actually used in a shop