Overview

The Client Cash Worksheet is a working report for collectors and cash posters. It lists customers with open invoices and provides entry lines for check #, AR amount, and adjustment code/amount so you can gather remittance info before posting cash. Print by customer or for all, in Detail or Summary format.

Screen & Prompts

Company — Posting entity.
Enter Report Ending Date — Include invoices dated through this date.
Specific Client, (ALL) — Enter a client code or type ALL to print the entire portfolio.
(D)etail, (S)ummary — Detail shows every open invoice with entry lines; Summary rolls to customer totals only.

Footer commands: Quit, Print.

Run the Worksheet — Steps

Confirm Company and enter the Ending Date.
Enter a Specific Client or leave as ALL.
Choose Detail or Summary.
Press P to Print to screen, printer, or file (per your output setup).

Sample Report

Detail format shows each customer with open invoices, contact info, and blank columns for Check #, AR Amount, Adj Code, and Adj Amt to capture remittances.

How to Use the Worksheet

During calls, note the customer’s check number, amount, and any adjustment codes/amounts (e.g., short‑pay, discount).
When payments arrive, use the worksheet as your guide in Cash Receipts and Apply Credits.

Tips

Run for ALL customers weekly to plan collection calls; run Specific Client for one‑off reconciliations.
Use Summary for leadership review; Detail for cash posters/collectors.