Accounts Receivable by Category

Generate a report showing each customer’s balance and how that balance is allocated to categories. This report may be used to help verify that entries were created properly in the General Ledger once the Update General Ledger program has been processed.

In this Topic

Accounts Receivable by Category
1. Watch a video
  1. How do I print the Accounts Receivable by Category Report by master category?
  1. How do I compare the Accounts Receivable by Category Report to the General Ledger?
  1. What do I do if the balances are different on the Accounts Receivable by Category Report and the Category Balance Report?
  1. Is there a way to review balances without printing reports? (at time marker 46m11s)
1. Print Accounts Receivable by Category
1. Options
  1. Include zero-balance categories
  1. Include zero-balance customers
  1. Print only customers with a credit balance
  1. Print only inactive customers
  1. Report dates
  1. Show credit categories for future invoices

Watch a video

Troubleshooting AR Balances 2018 Webinar (55m27s)

Updated 25Oct2018

How do I print the Accounts Receivable by Category Report by master category?

Troubleshooting AR Balances 2018 Webinar (55m27s) (at time marker 7m54s)

Updated 25Oct2018

How do I compare the Accounts Receivable by Category Report to the General Ledger?

Troubleshooting AR Balances 2018 Webinar (55m27s) (at time marker9m34s)

Use the Categories in the General Ledger to generate a report by account numbers. You'll need to set up each category to include all of the accounts in the category. Then, you'll print the Category Balance Report. The balances on the Category Balance Report from the General Ledger should match the balances on the Accounts Receivable by Category Report from the Accounts Receivable app.

Updated 25Oct2018

What do I do if the balances are different on the Accounts Receivable by Category Report and the Category Balance Report?

Troubleshooting AR Balances 2018 Webinar (55m27s) (at time marker 12m46s)

To begin troubleshooting, start by running Checkout to track down errors and transactions that have not been updated to the General Ledger. You can save time by deselecting the options to Only Include Transactions Since and Verify Statement Balances.

Updated 25Oct2018

Is there a way to review balances without printing reports? (at time marker 46m11s)

You can use Account Inquiry in the General Ledger app to review balances. You can use the Multiple Accounts to view category balances instead of printing the Accounts Receivable by Category Report. You can type in a group of account numbers to troubleshoot account balances.

Updated 25Oct2018

Print Accounts Receivable by Category

Set up the report options and send the report to the printer.

Do this...

1. Open Connect Accounts Receivable > Reports > Accounts Receivable by Category Report.

2. Select a report title.

3. Set up the report options.

4. Click Print (CTRL+P).

The report prints.

Options

Include zero-balance categories

Include zero-balance categories: Select the checkbox to print categories that have a zero balance. Deselect the checkbox to exclude categories with a zero balance from printing on the report.

Include zero-balance customers

A zero-balance customer is a customer who has a zero balance on their account.

Do you want to include customers that have a zero balance?

Yes, include customers that have a zero balance. Click to select Include Zero-balance Customers.
No, do not include customers that have a zero balance. Usually, this option is not selected. Click to clear the Include Zero-balance Customers.

Print only customers with a credit balance

Print only customers with a credit balance: Select the checkbox to print the report for customers who have a negative balance on their account. For example, a customer may have a credit balance when they have over paid.

Print only inactive customers

Print only inactive customers: Select the checkbox to print the report for customers who have an activation date that occurs after the report date, or the customer has a termination date that occurs before the report date.

Report dates

Report Dates is the report date range. The report will use the report date range to select transactions to print on the report.

Do you want to use the current month end?

Yes, I want to use the current month end. Continue to the next step.
No, I want to use a different date. Change the Report Date, or click Advanced Options.

Show credit categories for future invoices

Show credit categories for future invoices: Select the checkbox to include future payment applied records when determining the category balance.

Invoices, payments, credit memos, and deposits are processed as usual - with transactions restricted by report date - and the date restriction is removed for the payment applied transactions.

Showing credit categories for future invoices will include:

All payment applied amounts that occur after the report date, and
Are associated with payments.