Summary
A net increase in cash doesn't match the summary section's net increase in Sage 50 Accounting.
Cause
- General Ledger Account Type incorrect
- General Ledger integrity problems
- Incorrect account types
- The default design of the report doesn’t consider:
- Sales of depreciable (fixed) assets
- Adjustments to asset type accounts
- Adjustments to accumulated depreciation
Resolution
NOTE: We have hands-on instruction on designing financial statements available. 1. Customize the design to account for sales of assets and adjustments to accumulated depreciation
- Go to Reports & Forms, Financial Statements then select the Cash Flow statement. Click the Design button.
- Right-click the Column Desc. section after the Text-Body lines for Adjustments to reconcile net income to net cash provided by operating activities.
- Select Properties.
- In the Column Description window, click the Activity line.
- In the Activity Amount section, change the Qualifier from Only Credits to Net.
- Do the same for the Year to Date line, then click OK.
- Right-click the Column Desc. section after the Text-Body lines for Cash Flows from investing activities.
- Select Properties.
- In the Column Description window, click the Activity line.
- In the Activity Amount section, change the Qualifier from Only Debits to Net.
- Do the same for the Year to Date line, then click OK.
- Click the Save button and enter a new name for the custom statement.
2. Correcting the general ledger
- Print your Chart of Accounts, review each account number, and verify that it has the proper account type.
- If you find an account type that’s incorrect, go to Maintain, Chart of Accounts. Choose the desired account number, and correct the account type. Click Save.
- Run the Chart of Accounts / Journal Synchronization integrity check.
3. Incorrect account types
- Go to Maintain, Chart of Accounts.
- Verify that the accounts on your Chart of Accounts are of the correct Account Type.