Overview
The Accounts Receivable Detail page shows a detailed list of what your customers still owe you.
While Accounts Receivable Summary groups balances by customer and aging bucket, the Detail report breaks this down into individual receivable lines (for example, invoices or other charges) for the date range you choose.
Path in the app:
Financials → Accounts Receivable → Accounts Receivable Detail
URL: /dashboard/accounting-reports/receivable-detail
Key Features
From the page and module structure we can infer that Accounts Receivable Detail lets you:
Filter by date
Choose a date range so you see only receivables that fall within that period.Filter by location
Use the Locations filter to see receivables for a specific store or for All locations.Search by customer
Type a customer name in the search box to show only that customer’s items.View detailed receivable lines
Each row represents one receivable entry (for example, a document or transaction) with key information such as customer, date, and amount still outstanding.See aging information
As the Summary view already uses aging buckets (Current, 1–30 days, 31–60 days, etc.), the Detail report uses the same underlying data so you can see which items make up those balances.Export or print
Icons in the upper‑right corner (similar to the Summary page) allow you to download or print the report for sharing or record‑keeping.
Getting Started
Before you use Accounts Receivable Detail, make sure:
Customers and sales are already in the system
Customer records live under Customers in the main menu.
Sales and invoices are created through POS or other sales modules.
Once posted, they appear in Accounts Receivable.
You have access to Financials
Your user role must allow you to open Financials → Accounts Receivable.You know the period you want to review
Decide if you want to see receivables for today, this month, a custom period, etc.
How to open the report
In the left menu, click Financials to expand it.
Click Accounts Receivable.
Choose Accounts Receivable Detail.
The detail report page will open with default filters (usually the current period and All locations).
How to Use
1. Set your filters
At the top of the page you’ll see filter controls similar to the Summary report:
Location
Click the Locations dropdown.
Choose a specific store or select All to include every location.
The table will refresh to show receivables for that location selection.
Date range
Click the Date field (a date‑range picker).
Pick the start and end dates you want.
Confirm your selection; the report refreshes to show entries within that range.
Search customer
In the Search customer box, start typing a customer’s name.
Choose the customer from the suggestions (or press Enter).
The table now shows only receivables related to that customer.
Tip: If your total doesn’t match what you expect, first check that the location and date range are set correctly.
2. Understand the table
The main part of the page is a table listing your receivable entries.
While the exact column labels depend on your setup, you can expect to see information like:
Customer – who owes you money.
Reference or Document number – e.g., an invoice or transaction ID.
Date – when the receivable was created.
Amount / Outstanding balance – how much is still unpaid.
Aging – how old the receivable is, consistent with the Summary view’s aging columns (Current, 1–30, 31–60 days, etc.).
At the bottom (or top) of the table there is usually a Total row that adds up all listed items, so you can quickly see the total receivable balance for the current filters.
3. Change sorting or page through results
If the report shows many rows, you’ll have:
Paging controls (e.g., “Page 1 of N”) to move forward or back through pages.
Often, you can click on a column header (like Date or Customer) to sort by that column. If sorting is available, clicking the header will toggle between ascending and descending order.
Use these controls to focus on the items you care about (e.g., oldest entries first).
4. Export or print the report
In the upper‑right area of the page (similar to the Summary screen) you’ll see export icons. Common options are:
Download – export to a file (for example, CSV or Excel) so you can analyze in a spreadsheet.
PDF / Print – generate a printable version.
Share – send or share the report via your usual channels (if enabled).
To export:
Set your filters (Location, Date, Customer) as needed.
Click the appropriate export/print icon.
Follow your browser’s prompts to save or open the file.
Note: Exports usually respect the filters currently applied, so check your filters before downloading.
5. How this module connects to others
The Accounts Receivable Detail report doesn’t create or edit transactions itself. It shows data that comes from other parts of the system:
Sales / POS modules
Sales invoices and similar documents create receivable entries. When these are posted, they appear in the AR Detail and Summary reports.Customer payments (General Accounting / Accounts Receivable)
When you record payments or adjustments, they reduce the outstanding amounts that you see here.Accounts Receivable Summary
Uses the same receivable data but groups it by customer and aging bucket.If a customer’s total seems off in Summary, you can use the Detail report (filtered by that customer) to see the line items making up that total.
General Accounting / Books of Original Entry
The receivables shown here correspond to ledger entries in your accounting module. The Detail report helps you reconcile those books with what customers owe.
Troubleshooting
1. “The report is empty – no rows are showing.”
Check:
Date range – Make sure the start and end dates include when your invoices were created.
Location – If you picked a specific location, try switching to All.
Customer search – Clear the customer filter to see if the list repopulates.
Posting status – Ensure the sales documents are posted/approved, not still in draft in their original module.
2. “Totals in Detail don’t match Accounts Receivable Summary.”
Try this:
In Summary, note:
The Location.
The Date.
The Customer whose balance you’re checking.
Open Accounts Receivable Detail.
Apply the same Location and Date range.
Filter by the same Customer.
If differences remain:
Confirm there were no recent changes (new invoices or payments) between when you viewed the two reports.
If your system uses multiple currencies or special adjustments, check with your accounting team to see how those are handled.
3. “I see an item here that should be fully paid.”
Possible causes and checks:
Payment not posted
Make sure the payment entry has been created and posted in the payments/receipts module.
Payment applied to the wrong customer or document
Review the payment record to confirm it is linked to the correct customer and invoice.
Filters hiding part of the picture
Change the Date range to a wider period to ensure you see both the invoice and the payment in related reports.
If the issue persists, your accounting administrator may need to review the underlying journal entries.
4. “I can’t open Accounts Receivable Detail at all.”
This usually indicates a permissions issue.
Confirm you can open other Financials pages.
If not, your role may not include access to accounting reports.
Ask your system administrator to grant access to:
Financials → Accounts Receivable → Accounts Receivable Detail
5. “Export file doesn’t look right.”
Check:
Filters before export – Make sure you’re exporting with the correct date range, location, and customer selection.
Open in a spreadsheet app – Use Excel, Google Sheets, or another spreadsheet tool that can properly read CSV/Excel files.
Column mapping – If you’re using the exported data elsewhere (for example, in another system), verify that the receiving system expects the same column order.
If you follow the steps above, the Accounts Receivable Detail report becomes your main tool for answering the question:
“Exactly which invoices and entries make up this customer’s balance?”
Use it alongside the Accounts Receivable Summary and your sales/payment modules to keep your receivables accurate and under control.