Skip to content
logo Knowledgebase

Incorrect totals on Cash Flow statement

Created on  | Last modified on 

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

  1. Go to Reports & Forms, Financial Statements then select the Cash Flow statement. Click the Design button.
  2. Right-click the Column Desc. section after the Text-Body lines for Adjustments to reconcile net income to net cash provided by operating activities.
  3. Select Properties.
  4. In the Column Description window, click the Activity line.
  5. In the Activity Amount section, change the Qualifier from Only Credits to Net.
  6. Do the same for the Year to Date line, then click OK.
  7. Right-click the Column Desc. section after the Text-Body lines for Cash Flows from investing activities.
  8. Select Properties.
  9. In the Column Description window, click the Activity line.
  10. In the Activity Amount section, change the Qualifier from Only Debits to Net.
  11. Do the same for the Year to Date line, then click OK.
  12. Click the Save button and enter a new name for the custom statement.

2. Correcting the general ledger

  1. Print your Chart of Accounts, review each account number, and verify that it has the proper account type.
  2. 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.
  3. Run the Chart of Accounts / Journal Synchronization integrity check.

3. Incorrect account types

  1. Go to Maintain, Chart of Accounts.
  2. Verify that the accounts on your Chart of Accounts are of the correct Account Type.

 

Need more help?

Chat now