Skip to main content

Accounts Receivable Summary: A Step-by-Step Guide

Overview The Accounts Receivable Summary page shows how much your customers currently owe you and how long those balances have been outstanding. You can find it at:

Updated over 2 months ago

Financials > Accounts Receivable Summary

Overview

The Accounts Receivable Summary page shows how much your customers currently owe you and how long those balances have been outstanding.

You can find it at:

Financials → Accounts Receivable → Accounts Receivable Summary

On this screen you’ll see one row per customer and columns for each aging bucket (Current, 1–30 days, 31–60 days, 61–90 days, Over 90 days), plus a total. This helps you quickly see which customers are overdue and by how much.

Connected modules

This summary report works together with:

  • Accounts Receivable Detail – shows the individual invoices and transactions behind each customer balance.

  • Customers – where customer records are stored.

  • Sales / POS modules – where customer sales and payments are recorded, which then flow into Accounts Receivable.


Key Features

From the screenshot and module structure, you can use these functions on the Accounts Receivable Summary page:

  • Location filter – limit the report to one store/location or view All locations.

  • Date range filter – choose the document dates you want included in the aging.

  • Customer search box – search for a specific customer by name.

  • Aging buckets – see amounts per customer in:

    • Total

    • Current

    • 1–30 days

    • 31–60 days

    • 61–90 days

    • Over 90 days

  • Totals row – a “Total” row at the bottom adds up all customers in the list.

  • Summary panel – a “Customers” line above the table shows overall totals for all customers in the report.

  • Export & print icons (top‑right):

    • Download the report (for example to a spreadsheet format)

    • Generate a PDF

    • Print the report

    • Share/download using the generic download icon


Getting Started

  1. Open the module

    • In the left menu, click Financials to expand it.

    • Click Accounts Receivable.

    • Click Accounts Receivable Summary.

  2. Check your default filters

    • At the top of the page you’ll see:

      • Locations – defaults to All.

      • Date – shows a date range.

      • Search customer – empty by default.

    • The table below will refresh based on these filters.

  3. Understand the layout

    • The first section summarises the whole report (number of customers and total balances per aging bucket).

    • The second section is a detailed table with one row per customer and columns for each aging bucket.


How to Use

1. View overall Accounts Receivable by location and date

  1. Go to Financials → Accounts Receivable → Accounts Receivable Summary.

  2. In Locations, choose:

    • All – to see every location, or

    • A specific location – to see only that store or branch.

  3. In Date, select the date range you want included (for example, this month or this quarter).

  4. The Customers summary line will update, showing:

    • Total receivable balance

    • Current and overdue amounts by aging bucket.

  5. Review the totals to understand your overall exposure.

2. Review balances for a specific customer

  1. Use the Search customer box at the top.

  2. Type part of the customer’s name (for example, “mark marmol”).

  3. Press Enter or click the search icon.

  4. The table will filter to matching customers.

  5. For that customer’s row, read across:

    • Total – overall amount they owe.

    • Current – not yet overdue.

    • 1–30 / 31–60 / 61–90 / Over 90 days – overdue balances grouped by how late they are.

If you need line‑by‑line transactions, open Accounts Receivable Detail from the same Accounts Receivable menu.

3. Analyze which balances are overdue

  1. Keep Search customer empty to see all customers.

  2. Look across the 1–30, 31–60, 61–90, and Over 90 days columns:

    • Customers with values in these columns are overdue.

  3. Use your browser’s sort (if available) or scan visually to identify:

    • Customers with large amounts in Over 90 days (oldest debt).

    • Customers with growing amounts in 1–30 and 31–60 days (early warning signs).

  4. Use this list to plan follow‑ups, reminders, or credit holds.

4. Export or print the report

  1. Set your Location, Date, and Search customer filters the way you want.

  2. In the top‑right of the report area, click one of the icons:

    • Download / spreadsheet icon – export the report for use in Excel or similar.

    • PDF icon – create a PDF copy.

    • Printer icon – send the report to your printer.

  3. Save or print the file as needed.

The exported file will respect the filters you have applied (location, date range, and customer search).


Troubleshooting

The table is empty / shows no customers

  • Check the date range.
    Make sure the Date filter includes periods where you actually have customer invoices.

  • Check the location.
    If you select a specific location that has no receivables, the table will be blank. Try switching to All locations.

  • Clear the customer search.
    If you previously searched for a customer, clear the Search customer field and run the search again.

Balances look too high or too low

  • Confirm filters first.

    • Ensure the Date range is correct.

    • Ensure the correct Location is selected.

  • Compare with Accounts Receivable Detail.
    Open Accounts Receivable Detail and filter by the same location and date range to see the underlying transactions.

A customer is missing from the list

  • Make sure:

    • Their invoices fall inside the selected Date range.

    • Their transactions are posted as customer sales, not cash sales or other types that don’t create receivables.

    • You haven’t filtered them out via Search customer.

I can’t download or print the report

  • Try a different export icon. If one format fails, try another (spreadsheet vs PDF).

  • Check browser pop‑up blocking.
    Some browsers block new windows or downloads; allow pop‑ups/downloads for the DizLog site.

  • Refresh the page.
    Reload the browser tab and try the export again with a smaller date range in case the report is very large.


This Accounts Receivable Summary module is your main snapshot of customer debt: use it regularly to monitor overdue balances, decide which customers to follow up, and confirm that your sales and payments are being recorded correctly across DizLog.

Did this answer your question?