Financial Reports Overview

Prints a register of all vouchers processed by the update including distribution details and totals.

Prints a register of all computerized checks issued during this A/P check run (in order by vendor number). The checks are split into separate reports depending on the value in the Currency field on the Vendor Profile tab.

CURRENCY CODE
blank - Canadian vendor
A - American vendor
and any other codes as set up on the Currency screen.

Prints a list of all outstanding A/P vouchers. When printed with the A/P Month End, it excludes future vouchers and includes future checks that have been issued. The report prints in voucher number order (one line for each voucher) showing total gross, discount, net amount and partial payment for each vendor. Totals are also printed for each voucher payable account, division and company showing the totals for gross, discount, net amounts and partial payments.

Note:  If an outstanding voucher is changed to be paid by a rapid remittance check then a line will print immediately after the voucher line indicating the rapid remittance check number on which the voucher was issued.

Prints a list of all outstanding A/P vouchers that have a due date less than or equal to a specified due date (entered by the operator in this run). The report prints in voucher number order (one line per voucher) showing total gross, discount, and net amount for each vendor. Totals are also printed for each bank account, division and company showing the total for gross, discount, and net amount.

Prints a register of all adjustment vouchers (Type is set to Adjustment on the Vouchers Information screen) that have been entered since the last A/P voucher update, A/P check run, or A/P month end has been run. One line prints for each voucher number and totals are printed for each vendor showing the total gross, discount, and net amounts for each vendor showing the total gross, discount, and net amounts for each vendor. The check number that each adjustment voucher applies to is also printed. Totals are also printed for each bank account, division and company.

Prints a detailed list of all G/L profit/loss transactions (Type Profit/Loss on Account Profile tab) that were allocated through the accounts payable system for the current A/P month. Totals are printed by G/L account (account/profit center), division and company.

Prints a detailed list of all transactions that were keyed through Cash Receipts on Financial Management. Totals are printed for each G/L account and division.

Note:  This report shows the transactions that made up the totals for the G/L accounts that were shown on report AR0025.

Note:  The phrase $ Automatic Transfer $ may appear in the Customer Name column of this report to represent a batch total.

Prints a detailed list of all transactions that were keyed through Cash Receipts on Financial Management for the desired C/R day (or desired A/R month if running A/R Month End).

Note:  The word 'UPDATE' will print after the report title if this report was produced by option 14. Cash Receipts Update on menu ARCR01.

Prints a list of all customers who have outstanding accounts receivable balances that are determined to be overdue according to the values on the Late Charges screen. The report shows the amount overdue, and the late charge that is being charged. Totals are printed for each branch, division and company.

Note:   All credits are applied to the oldest aging balance to reduce overdue balances before late charge % is applied.

Prints a summary of all customers who have outstanding accounts receivable. If a customer appears on this report with no details, then this customer has A/R activity in the current month but there are no outstanding accounts receivable.

The report shows the present accounts receivable status for each customer by aging period. Totals are printed of each aging period in relation to the overall total. A final total page also prints showing the opening A/R balance for the current month, the amount of A/R entered through the billing screens for the current month, the amount of accounts receivable keyed through cash receipts for the current month, and the new A/R balance for the current month.

The code that prints to the right of the customer name is each customers A/R Type. For example:
T - True balance forward
B - Balance forward
O - Open item

Prints a list of all checks that were cancelled through the Check Reversal screen for the current A/P bank rec month or through 10. Key Bank Rec on menu PAYR01 for the current payroll bank rec month. Totals are printed for each G/L month, each currency and for each division.

Note:  Checks are designated as cancelled if a 'C' is put in the CODE field in the Key Bank Rec screens. The system name (A/P or Payroll) will print on the report headings.

Lists customer number, customer name, invoice number, invoice amount and billing date by co/div/br then by customer number.

The accounts included in the invoice amount column are set up as cash, A/R, or charge accounts (A/R Agencies) in the system configuration.

This report lists each individual journal line and period range for the selected criteria. The selection criteria is listed at the top of the report. Generate the report from the Journal Breakdown screen.

This report lists a one-line summary of journal data for the selected criteria. The selection criteria is listed at the top of the report. Generate the report from the Journal Breakdown screen.

This report lists all stock number's that have been returned to inventory (status 'V') in this billing run. A credit invoice has been issued to reverse a sales invoice that was issued in a previous billing run.

This report prints a summary by G/L account within profit center showing monthly and year to date totals for budgets, actual, last year actual and YTD variance. Sub totals are printed combining all accounts with the same first 3 digits. Sub-totals are also printed for total sales, cost of sales, Gross Margin The profit percentage of the selling price. Revenue - Cost of Goods Sold = Gross Margin and expenses (e.g. change in first digit of G/L account) Report DE1100-S only prints the sub-totals for total sales, cost of sales, gross margins, expenses, and the totals for profit center, division and company.

Note:  Year to date variance is calculated as: Year to date ACTUAL - Year to date BUDGET

The final and preliminary are identical reports except for the headings FINAL and PRELIMINARY.

This report prints a summary by profit center within the first set of profit center groupings (as set up on the Profit Centers screen) showing monthly and year to date totals for budgets, actual, last year actual, and YTD variance.

Note:  Report number DE1120-1 is the same as DE1120-0 except all profit center groupings are printed on one page.

This report prints a summary by G/L account within the first set of profit center groupings showing monthly and year to date totals for budget, actual, last year actual, and YTD variance. Sub-totals are printed for accounts with the same first three digits. Sub-totals are also printed for total sales, cost of sales, gross margin and total expenses (e.g. change in the first digit of the G/L account). Report DE1160-S only prints the sub-totals for total sales, cost of sales, gross margins, expenses, and the totals for profit center groupings, division and company.

Note:  Year to date Variance is calculated as: Year to date ACTUAL - Year to date BUDGET. This report will also print a summary by G/L account within the second profit center grouping if desired. Profit center groupings are set up on the Profit Centers screen.

Prints a statement of change in financial position report. The G/L accounts and totals (current and YTD) are determined by the value coded in CASH TYPE for each balance sheet account through the Account Profile tab.

EARNINGS—Total of all non balance sheet accounts.

NON CASH ITEMS— Total of all balance sheet accounts coded with CASH TYPE equal to "N"

DECREASE IN ASSETS—Total of all balance sheet accounts coded with CASH TYPE equal to "L", ASS/LIAB equal to "A", with a credit balance.

INCREASE IN LIABILITIES—Total of all balance sheet accounts coded with CASH TYPE equal to "L", ASS/LIAB equal to "L", with a credit balance.

TOTAL SOURCE OF FUNDS—Total of EARNINGS, NON CASH ITEMS, DECREASE IN ASSETS, and INCREASE IN LIABILITIES.

INCREASE IN ASSETS—Total of all balance sheet accounts coded with CASH TYPE equal to "L", ASS/LIAB equal to "A", with a debit balance.

DECREASE IN LIABILITIES—Total of all balance sheet accounts coded with CASH TYPE equal to "L", ASS/LIAB equal to "L", with a debit balance.

TOTAL USE OF FUNDS—Total of INCREASE IN ASSETS, and DECREASE IN LIABILITIES. NET FUNDS FROM OPERATION SOURCE OF FUNDS minus USE OF FUNDS.

WORKING CAPITAL START OF PERIOD—The starting period total for all balance sheet accounts coded with CASH TYPE equal to "C".

WORKING CAPITAL END OF PERIOD—The ending period total for all balance sheet accounts coded with CASH TYPE equal to "C".

This report lists all general journals that were entered through the Journal Listing screen and all system generated journals for the current month.

Note:  If the option to print all journals regardless of G/L date is selected, then all journals will be printed. If the option to print only journals that match the desired G/L month is selected then only journals that have a G/L date equal to the desired G/L month or have a G/L date equal to '9999' will be printed.

When the G/L final is run for the last month of the fiscal year, a year end closing journal is printed. The journal prints all G/L accounts and their end balances which will be set to zero. The journal also prints the adjusted retained earnings balance after the total of all the G/L accounts that appear on this journal has been applied.

This report only prints when the G/L month end final is run for the last month of this company's fiscal year.

Prints a summary of all billing G/L allocations for the current G/L month in standard journal format.

This report prints a listing of all transactions that have been allocated to selected G/L accounts in the sub-ledger system (the Subledgered Account field is selected on the Account Profile tab).

CREDITS
This report will only print if the method of posting credits is through the Subledger screen. The report will print all transactions that have credits or adjustments applied against them. When sub-ledger month end is run all these transactions and their corresponding credits are removed from the sub-ledger file (MONTH END will print on the report heading).

OUTSTANDING
If the method of posting credits is through the Subledger screen, then all transactions that have had no credits or adjustments applied against them will print. If the method of posting credits is through billing, cash receipts or accounts payable, and not through the Subledger screen then all transactions will print on this report. Sub-totals will print showing the net balance for each invoice number (or reference number). The number of days that this invoice number (or reference number) is outstanding will also print on this report.

Note:  Reference number is stored in the 1st eight positions of the description field. A total page will also print showing an aged analysis of all the outstanding transactions.

Note:  The total page only prints on the sub-ledger outstanding (report SLE002-10) when the report is printed in order by invoice number or reference number. The total page will not print if any other sort order is selected. If the net balance for all transactions having the same invoice number (or reference number) equals zero, then that set of transactions is not included in the number of claims total. The days outstanding only prints if you selected sort type 2 or 6.

When the subledger month end is run all transactions having the same invoice number (or reference number) whose net balance is less than the maximum write off debit amount and greater than the maximum write off credit amount entered by the operator during this run, are removed from the subledger file.

For Example:
If the maximum write off amount is $7.00, then all transactions will be written off if the net amount outstanding for the invoice# is greater than or equal to a $7.00 credit and less than or equal to a $7.00 debit. (MONTH END will print on the report heading).

Prints a detail listing of all items received from a selected Purchase Order grouped by the Date Received and Sequence of receipt. Partial receipts completed on the same day or on subsequent days impact the data displayed on the purchase order receipt history report. The report lists:

• Date Received
• Sequence (the order in which the items were received on the Date Received)
• Comments
  
• Item Number and Description
• Quantity Ordered, Received, Back Ordered, and Cancelled
• Unit Cost
• Extended Cost (Qty Rec x Cost)
• Total Received and GL Totals, Total Back Ordered, and Total Cancelled for Date Received
• Total Received, Total Back Ordered, and Total Cancelled for the selected Purchase Order

Prints a detail listing of all items received from a selected Purchase Order grouped by the Date Received and Sequence of receipt. Partial receipts completed on the same day or on subsequent days impact the data displayed on the purchase order receipt history report. The report lists:

• Date Received
• Sequence (the order in which the items were received on the Date Received)
• Stock Number
• Base and Option
• Description
• Comments
• Status
• Extended Cost
• Total Received and GL Totals, Total Back Ordered, and Total Cancelled for Date Received
• Total Received, Total Back Ordered, and Total Cancelled for the selected Purchase Order

Prints a list of all outstanding A/P vouchers. When printed with the A/P Month End, it will exclude future vouchers and include future checks that have been issued. The report prints in voucher number order (one line for each voucher) showing total gross, discount, net amount and partial payment for each vendor. Totals are also printed for each voucher payable account, division and company showing the totals for gross, discount, net amounts and partial payments.

Note:  If an outstanding voucher is changed to be paid by a rapid remittance check then a line will print immediately after the voucher line indicating the rapid remittance check number on which the voucher was issued.

Prints a detailed listing of all vendors selected and their corresponding data fields. Vendors can be selected that are coded for accounts payable and/or parts, and can be printed in the order of vendor number or search key.

Note:  For each vendor, this report shows the total purchases, discounts taken, and amount issued for the current fiscal year and for all of the previous fiscal year. The report also shows the amount issued for the current calendar year and for all the previous calendar year. When the last accounts payable month end is run for the fiscal year, the current year totals are moved to last year and the current year totals are set to zero. When the last accounts payable month end is run for the current calendar year, the current calendar year total is moved to last year and the current year totals are set to zero. This will cause the total amount issued to possibly be greater than the total purchases (e.g. the purchase was made in the last month of the fiscal year, but the check was not issued to the vendor until the next fiscal year).

Prints a summary of selected customers who have outstanding accounts receivable. If a customer appears on this report with no details, then this customer has had A/R activity in the current month but there are no outstanding accounts receivable.

The report shows the last updated accounts receivable status by aging period for each customer that matches the selected criteria of this run (e.g. customers that match the branches, invoices 1st digits, salesperson, territories and aging periods selected.) Totals are printed for each aging period in relation to the overall total. If the option is selected to print by salesperson, then aging period total percentages will print for each salesperson selected.

The code that prints to the right of the customer name is each customers A/R TYPE. For example:
T - True Balance forward
B - Balance forward
O - Open Item

Prints an analysis by vendor of all G/L transactions that have been generated through the accounts payable system for the current A/P month, year to date for the current A/P year or year to date for a previous A/P year. If running the detail report, each G/L transaction is shown and totals are printed for each account/profit center, account number, A/P distribution date, vendor, division, and company. If running the summary report, only the totals are printed for each A/P A/P distribution date (optional), vendor, division and company.

Note:   When the current month option is selected the A/P distribution dates will always print as zeros. "YEAR TO DATE ALLOCATIONS" will print on the report heading for both year and previous year options.

Prints an analysis by G/L account of all G/L transactions that have been generated through the accounts payable system for the current A/P month, year to date for the current A/P year or year to date for a previous A/P year.

If running the detail report each G/L transaction is shown and totals are printed for each A/P distribution date, account profit center combination, account number, division, and company. If running the summary report, only the totals are printed for each A/P distribution date (optional), account/profit center, account number, division, and company.

Note:  When the current month option is selected the A/P distribution dates always print as zeros. "YEAR TO DATE ALLOCATIONS" print on the report heading for both current year and previous year options.

Prints a list of the general ledger chart of accounts and their corresponding data fields keyed through option 3. Chart Of Accounts Maint. Ytd Amt ------- The year to date balance as of the last G/L (XX XX) month end final. The month and year of the last G/L month end final is printed under this heading. Cur Ytd Amt The current year to date balance for this G/L account as of the last time data base reorganize was run.

Note: If transactions have been processed for the next fiscal year and the G/L final has not been run for the previous fiscal year, then the balances for the profit and loss and expense accounts as of the fiscal year end are transferred to earnings, the account totals are then set to zero and the transactions for the next fiscal year are accumulated.

For example:
- fiscal year end is November 2005
- the last G/L final run is October 2005
- transactions have been processed for December 2005.

The CUR YTD AMT for profit and loss and expense accounts will only show the total of the December 2005 transactions. The YTD AMT plus the November 2005 transactions will have been added to the CUR YTD AMT for the retained earnings G/L account. See the General Ledger manual in the Chart Of Accounts Maint chapter for the description of each data field. If a G/L account is deleted, a 'D' prints in the right side of the report.