MSAMM
Back to course

Implementing Cloud Financials: From Empty Pod to Go-Live · Module 12 · Financial Reporting

Building a balance sheet

Lesson 118 of 153 · 18 min

Create a report, insert a grid, and set the rows from the account hierarchy you built earlier. Set the columns to the accounting period. Configure the point of view: ledger, period, currency type, amount type. Add the four asset subtotals the controller asked for, format it — headers, number formats, suppression of zero rows — run it, and verify the total agrees to the trial balance. Then save it into the folder structure you designed. The point of view is where reports go wrong. Set it deliberately and say each choice out loud as you make it; three of the failures in this module are a point of view somebody set without thinking. Verify against the trial balance every time. A balance sheet that does not tie is not a formatting problem, and treating it as one is how a wrong number reaches a board pack. If the hierarchy was

The full lesson is part of the course

The video, the complete written lesson and the module quiz are included in Implementing Cloud Financials: From Empty Pod to Go-Live, with a certificate on completion and a fourteen-day refund window.

Get the free lessons by email

We will email you a link to every free lesson in this course. No account needed, and one message only.

In this module: Module 12 · Financial Reporting

  1. 1Four tools, one questionFree preview
  2. 2The balances cube
  3. 3Account inquiry and account groups
  4. 4Folders, permissions and connections
  5. 5Building a balance sheet
  6. 6Building a P&L with comparatives
  7. 7Smart View for ad-hoc analysis
  8. 8Operational reporting and dashboards
  9. 9What breaks
  10. 10Lab: build the CFO pack