Consolidated Balance Sheet Report

The Consolidated Balance Sheet displays the distribution of your enterprise's assets, liabilities, and net worth as of the current date of a consolidation group.

The report also includes totals for assets, liabilities, net worth, and liabilities + net worth. Total assets should equal total liabilities plus net worth. If these totals do not agree, the amount of the discrepancy displays at the end of the report.

Settings that Affect General Ledger Reports

You can only generate the cash-basis version of this report if you select the Cash Basis Reporting option on the Options form (Settings > General Ledger > Options).

The Organization Record Access setting for your role on the Overview tab of the Roles form (Settings > Security > Roles) determines the organizations for which you can see data on this report.

Organizations and Separate Balance Sheets

If you use organizations, use the Maintain Separate Balance Sheets by Organization option on the Organization General Setup form (Settings > Organization > General) to specify whether or not you want to maintain the data needed to generate a separate Balance Sheet for each organization.

You have the following choices:

• If you do not want to maintain separate Balance Sheets, you specify a default organization on the Organization General Setup form. Vantagepoint assigns all explicit and implicit postings to balance sheet accounts to this default organization. You do not need to enter a project number when you enter a transaction that affects a Balance Sheet account. When you generate a Balance Sheet, Vantagepoint generates the report for the company as a whole, using the data for the default organization.
• If you do want to maintain separate Balance Sheets, you enter a project number for every transaction that affects the balance sheet accounts. Vantagepoint uses the project number to determine which organization receives the posted transaction. The result is that Vantagepoint tracks transactions affecting balance sheet accounts by organization. Because of that, you can generate Balance Sheets for individual organizations or generate a Balance Sheet for the company as a whole.

No similar option exists for the Income Statement because Vantagepoint automatically tracks the data required to generate a separate Income Statement for each organization.

Link Bank Codes and Liability Codes to Organizations

To maintain separate Balance Sheets, you must also:

• Link each of your bank codes to an organization on the Bank Codes settings form (Settings > Cash Management > Banks).
• Link each of your accounts payable liability codes to an organization on the Liability Accounts tab of the Accounts Payable settings form (Settings > Cash Management > Options).

Account Groups

You can use account groups to organize accounts on financial reports. You establish account groups on the General tab of the Accounts form (Settings > General Ledger > Chart of Accounts).

Multiple Currencies

If you use multiple currencies, a report may display amounts in different currencies. If a report contains a total for amounts in a mix of currencies, the report displays #### as the total, instead of an amount. If the report displays amounts in different currencies, it is a good idea to include currency symbols or currency codes. To do that, click the Layout tab of the report and click in Currency Setting Sample to open the Format Currency dialog box. You may want to use the currency code in place of the currency symbol when the report includes more than one currency with the same symbol. For example, U.S. dollars and Canadian dollars both use $ as the currency symbol. If you use the code rather than the symbol, the report displays USD and CAD instead of $.

An alternative to mixing currencies on the report is to select a presentation currency. When you generate the report, Vantagepoint converts all amounts to the presentation currency. The advantage of this method is that you can make meaningful comparisons between amounts, and the report can display meaningful totals.