How to reconcile FRx trial balance reports with General Ledger in Sage PFW 

Entry Type: Informational

Product: FRx

Application: FRx Desktop

Version Reported: All

Subject:

How to reconcile FRx trial balance reports with General Ledger in Sage PFW 

Possible Resolutions:

If the report is out-of-balance when running it with Posted and Unposted Balances selected in FRx:

• Browse to the x:\Platinum\company ID\ folder (x = drive letter for the Sage PFW server), and ensure that temporary files have been created. For more information, see What temporary files does Sage PFW create that FRx uses for reporting.
• Run the Period Edit List in General Ledger to check for error messages.
• Ensure that all transaction on the Journal Batch Entry window are all in-balance.

If the report is out-of-balance when running it with Posted Balances Only selected in FRx:

• Ensure that all entries are posted for the year.
• Ensure that the period-end date is created for the next year.
• Run the Year End Edit List for the year. This report shows out-of-balance issues for the Current Earnings account and the Income Summary account. For more information, see *E-BALANCE SHEET OUT OF BALANCE" and "*E-INCOME STATEMENT OUT OF BALANCE" by the same amount when running the Year End Edit List.
• If the out-of-balance issue is related to an account other than the Current Earnings account or the Income Summary account:
1. In Sage PFW, run a General Ledger report for posted balances only.
2. In FRx, run a trial balance report:
1. Create a row format. Enter the following, and then save the row:
• Column B = All Accounts
• Column F = Use format code XO for "Suppress Row if All Zeros (Override)"
• Column H = ????
  Note: The question marks represent the number of characters used in the main account segment on the chart of accounts. Use one segment only (rather than ????-????) for the main account.
2. Create a column layout. Enter the following, and then save the column:
• Column A = ACCT
• Column B = DESC
• Column C = GL; A; BASE; BASE; CUR/BB
• Column D = GL; A; BASE; BASE; CUR; Column Restriction = DR
• Column E = GL; A; BASE; BASE; CUR; Column Restriction = CR
• Column F = CALC; C+D-E
• Column G = GL; A; BASE; BASE; YTD
• Column H = CALC; F-G
3. Create a catalog of reports:
1. Enter a catalog ID and name.
2. Select the row format.
3. Select the column layout.
4. Select the reporting tree (optional).
5. Save the catalog.
3. Generate the FRx report, and compare the totals to General Ledger in Sage PFW. The figures should match.
4. Adjust discrepancies in the Period Balance file.
   Note: Use caution when modifying the Period Balance file. Always make a backup first. Changes should be made only if you have a thorough understanding of the file. If necessary, contact Sage PFW Customer Support for assistance.