Summary A/R Ledger
|
Access this report using Reports>Accounts Receivable>Summary A/R Ledger. |
Use this report to print a list of invoices including the amount due. This is a summary style ledger that contains data from the detail ledgers and summarizes all entries for an A/R invoice, credit, or receipt. The detail entry amounts for an invoice are netted together creating a summary amount due. This report:
- Assists in reconciling Accounts Receivable balances. It is also useful for audit purposes or for researching customer payment questions.
- Summarizes all entries within an invoice, while the Detail A/R Ledger report prints each entry in detail.
Advanced Security Users
Account Level Security is available for this report. This feature allows the Administrator to define the account codes and related amounts a user can view in the report. When account level security is activated by the Administrator for the organization (Security>Set Up Account Level Segments) and enabled for a user or group (Security>Set Up Account Level Security), the report will only print account information the user is allowed to see. Note that if a user does not have Account Level Security enabled, the user will see all account codes.
If the "Print Disclaimer on Report" check box is selected on the Security>Set Up Account Level Segments form, "This report may be affected by Account Level Security" prints in the header of this report. In that case, an * also prints after the report title.
Multicurrency Users
The Invoice Source Amount, Source Currency, Source Currency Description, Source Beginning Balance, Source Current Balance, and Source Net Change columns are only available if the Administrator has installed and added this module (Organization>Add a Module). "Source" currency columns follow the formatting of the source currency, while other currency columns follow the functional currency.
Report Criteria
Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report. Current Period Dates are also required to specify the reporting period for this report.
Use this tab to determine what data to include in the report and to define the report layout.
- By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
- By selecting Available Columns, the data that appears in the body of the report is determined.
|
Column |
Description |
|
Class |
This item is used to limit or sort a range of customer IDs. Assign it to different IDs so that they can be grouped together. The report shows the class-Financial Counseling or Budget Counseling, for example. |
|
Type |
This is used as a second-level sort for Class. Use it to limit or sort a range of customer IDs. For example, within the Class Financial Counseling, you might assign Types Bankruptcy, Debt Consolidation, or Refinancing. The report would show these types. |
|
Customer ID |
The customer selected on the Transactions>Accounts Receivable>Enter A/R Invoices form. |
|
Customer Name |
The name assigned to the customer using the Maintain>Accounts Receivable>Customers form. |
| Status | The status of the customer ID-Active, Inactive, or Discontinued. |
|
Invoice/Credit Number |
The invoice or credit number entered during transaction entry. |
|
Invoice/Credit Date |
The invoice or credit date entered during transaction entry. |
|
Due Date |
The due date entered during transaction entry. |
|
Invoice/Credit Description |
The description entered during transaction entry. |
|
Invoice/Credit Amount |
For functional currency, the invoice or credit amount entered during transaction entry. For non-functional currency, the Invoice/Credit Source Amount times the Exchange Rate. |
|
Invoice/Credit Source Amount |
For non-functional currency, the invoice or credit amount entered during transaction entry. |
|
Credit Type |
The credit type of Applied Credit, Prepayment, or On Account displays. This was selected on the Enter A/R Credits and Enter A/P Credits forms. |
|
{Segment Name} Code |
The account code associated with the invoice. The report prints the account code, such as, 201, 05, or 45001. The system displays one column for each code type, such as Fund Code or GL Code. |
|
{Segment Name} Title |
The title associated with each code above. The system displays one column for each code type, such as Fund Title or GL Title. |
|
{Segment Name} Short Title |
The short title for the title above (15 characters or less). The system displays one column for each code type, such as Fund Short. |
|
{Segment Name} Group Code |
The group code that was defined. The report prints a column for each group code, such as Fund Group Code. |
|
{Segment Name} Group Title |
The title associated with the group code above. The report prints one column for each group segment. |
|
{Segment Name} Group Short Title |
The short title for the group title above (15 characters or less). The report prints one column for each group segment, such as Fund Group. |
|
Source Currency |
The source currency type associated with the transaction, such as USD, MXN, or CAD. Currencies were created and activated by the Administrator using the Organization>Currency Setup form. |
|
Source Currency Description |
The description associated with the currency, such as US Dollar, Mexican Peso, or Canadian Dollar. |
|
Beginning Balance |
The total functional amount of all transactions with an Effective Date before the Opening Balances date that was entered on the Setup tab. This balance only includes transactions with an entry type of Beginning Balance, Normal, or End of Year Adjustment. |
|
Current Balance |
The total functional amount of all transactions with an Effective Date between the Opening Balances and Ending Balances dates that were entered on the Setup tab. This balance only includes transactions with an entry type of Beginning Balance, Normal, or End of Year Adjustment. This amount takes into account revaluations (Activities>Revalue Multicurrency). |
|
Net Change |
The difference between the Current Balance and the Beginning Balance. |
|
Percent Increase (Decrease) |
The percent increase or decrease between the Current Balance and the Beginning Balance. |
|
Invoice/Credit Source Beginning Balance |
The total source amount of all transactions with an Effective Date before the Opening Balances date that was entered on the Setup tab. This balance only includes transactions with an entry type of Beginning Balance, Normal, or End of Year Adjustment. |
|
Invoice/Credit Source Current Balance |
The total source amount of all transactions with an Effective Date between the Opening Balances and Ending Balances dates that were entered on the Setup tab. This balance only includes transactions with an entry type of Beginning Balance, Normal, or End of Year Adjustment. |
|
Invoice/Credit Source Net Change |
The difference between the Invoice/Credit Source Current Balance and the Invoice/Credit Source Beginning Balance. |
|
Payment Method |
The form of payment selected on the Receipt Writing form using Activities>Receipt Writing or Enter A/R Receipts form using Transactions>Accounts Receivable>Enter A/R Receipts. |
|
{User Defined Field} - Customers |
A customers type user defined field and its data. There will be a separate column for each field that was created by the Administrator using Organization>Set Up User Defined Fields. |
|
{User Defined Field} - Transaction Documents |
A transaction document type user defined field and its data. There is a separate column for each field. |
|
{User Defined Field} - A/R Invoices |
An A/R Invoice type user defined field and its data. There will be a separate column for each field. |
|
{User Defined Field} - A/R Invoice Detail |
An A/R Invoice Detail type user defined field and its data. There will be a separate column for each field. |
Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.
Use this tab to designate the Group Sets for the report. Groups provide an alternate way of reporting summarized accounting data. Selecting a group code on the report is the same as filtering by group code on the entire report. Any accounts not included in a Group Set will not be included in the report. In order for groups to be applied to the report, the group selected on the Groups tab must also be selected in at least one of the following: Content tab or Filter tab.
Use this tab to set up any Available Options for the report.
|
Options |
Description |
|
Year-End Adjustments |
Select this option to include year-end adjustments on the report. This entry type was designated during transaction entry. |
|
Suppress Lines with All Zeros |
Select this option so that documents with zero amounts do not print. This eliminates records having zero in all amount columns. If it is not selected, every line prints, even if it has a zero value. |
Use this tab to change the font and page setup for a report.
Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.
- To print a report that shows an opening balance by customer, select Customer ID on the Content tab. A report cannot be printed that shows an opening balance by Customer Name. However, select Customer Name as well as Customer ID on the Content tab, and the report shows the Customer Name.
- The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).