Article ID: 8255

Consolidating G/L Statements for Two Sets of Books

In PCLawPro, you can consolidate Financial Statements for two separate sets of books. The G/L accounts for both sets of books appear on the same statement when you consolidate. A consolidated statement combines G/L accounts with the same nickname.

NOTE:

Data does not transfer from one set of books to the other when you consolidate statements. PCLaw® combines the totals from each set of books to create a single statement.

Because both sets of books might not have the exact G/L account names or numbers, you can create matching parent accounts in both sets of books to streamline the appearance of consolidated statements. When you run the statements, select to show only parent accounts or select to show parent and sub accounts on the statements.

Take the following steps to produce consolidated statements:

  1. Click G/L and select Statements... to open the Statements window.
  2. Click to check the General Ledger box, and select a template for it.
  3. Click to check the Trial Balance box, and select a template for it.
  4. Click to check the Income Statement box, and select a template for it.
  5. Click to check the Balance Sheet box, and select a template for it.
  6. Select Range from the G/L Account Selections box.
  7. Select First Current Asset from the Start drop-down list.
  8. Select Last Expense from the End drop-down list.
  9. Enter the period start and end dates in the Current Report Period date boxes.
    NOTE: Click Use Previous to run the report for the same dates as the last statement you ran. Click Default to run the report for the next open period.
  10. Click to check the Detailed box to show each debit and credit on the report or uncheck it to only show balances for each G/L account.
    NOTE: Summarized G/L accounts only show a summary of debits and credits on the report, even when you check the Detailed box.
  11. Select Output options.
  12. Click the Other tab.
  13. Click to check the Run Consolidating Statements box.
  14. Click to highlight the set of books you want to consolidate with the currently open set of books.
  15. Enter the ADMIN ID for the highlighted set of books in the User Name box.
  16. Enter the password for the ADMIN ID in the Password box.
  17. Click OK to generate the consolidated statements.
    NOTE: Click Yes if you get the Do you want to re-read G/L information? prompt.