Review financial statements
/review checks a set of financial statements from its PDF: the sums, the figures carried over from the prior year, the tie-out to the trial balance, and what changed in the text of the notes.
| What Moby does | Reads the statements, runs up to four checks, adds one tab per check to your workbook and marks the PDF with what it verified |
| Use it when | You receive financial statements to review, a draft or a final version |
| You need | The PDF of the statements of year N. For the full review, the PDF of N-1 and the trial balance of year N |
| Limits | The first 200 pages of each document |
The four checks
| Check | What it verifies | Needs | Tab |
|---|---|---|---|
| Arithmetic | The totals of every table add up, down the columns and across the rows | Year N only | Arithmetic check |
| Prior year | The N-1 column of the year-N statements equals the figures of the N-1 statements | The N-1 document | N-1 tie-out |
| Trial balance | Each line of the balance sheet and of the income statement ties to the accounts of the trial balance | The trial balance | TB check |
| Text | What was added, removed or reworded in the notes since N-1 | The N-1 document | Text vs N-1 |
A check whose input is missing is skipped. A tab is added only when its check has something to show.
Run it
- In the Workflows tab, click Review financial statements, or type
/reviewin the chat. - Step 1 of 3. Select the statements of year N, then Next.
- Step 2 of 3. Select the statements of N-1, or click Skip N-1.
- Step 3 of 3. Say where the trial balance of year N comes from.
- Click Check. When the card says Review financial statements complete, the tabs are in your workbook.
The trial balance
| Choice | What to give |
|---|---|
| TB in an Excel range | Select the trial balance in a sheet, with its header row: account, label and amount. Then click Use the selection. At most 7 columns and 1,000 rows |
| Year N FEC file | The FEC of year N: a text file (.txt, .csv, .tsv) or an Excel export (.xlsx, .xlsm), with the statutory FEC columns. Moby computes the trial balance from the entries |
| No trial balance | Nothing. The trial balance check is skipped |
For the amount, give either one balance column, or the debit and credit columns.
What you get
The tabs
Each of the first three tabs opens with a list, To verify, of the values that did not tie. Each row gives the value, what was expected, the difference and a link to the cell. When everything ties, the tab says "Every value validated".
| Tab | What a row is | Columns |
|---|---|---|
| TB check | A line of the statements tied to the trial balance. A copy of the trial balance sits next to it, with the line each account was assigned to | FS line, Page, FS N, TB amount, Delta, Status, Reason |
| N-1 tie-out | A line of year N with its prior-year figure | Label, Page, FS N (N-1 column), FS N-1 (N column), Delta, Status |
| Arithmetic check | The tables of the PDF, rebuilt in Excel. Each checked total is a formula, green when it matches the document and orange when it does not | The columns of each table |
| Text vs N-1 | A passage of the notes that changed | Page, Nature, Text N, Text N-1, Context |
Click a figure in a tab: the Preview opens the page of the PDF, with the figure highlighted.
The marked PDF
Click Download marked PDF on the card. It is the year-N PDF with a mark on every figure Moby verified. A legend is printed on the first page.
| Mark | Meaning |
|---|---|
| Orange ⊥ | The figures above add up to this total |
| Orange ⊣ | The row adds up across its columns |
| Blue barred tick | The figure matches the N-1 document |
| Ochre tick | The figure ties to the trial balance |
| Yellow fill | A figure that does not tie to the trial balance, in a table that mostly does |
| Green fill | Text identical to N-1 |
What carries no mark and no green is what remains to be read. The ticks and notes you add yourself in the Preview are printed on the marked PDF too.
Watch out
- A mark says the figure agrees with another figure. It does not say the figure is right.
- The review follows the accounting standard of your profile, PCG or INTL. Check it in the account menu before you launch.
- The text check leaves tables aside: their figures are covered by the other three checks. A passage that differs from N-1 only by the year is not listed.
- Download the workbook appears in place of the tabs when Excel could not insert them: an older Excel, tabs too large for Excel on the web, or a tab name already taken. The workbook holds the same tabs.
- "No primary financial statement lines could be extracted" means Moby did not find the balance sheet and the income statement in the PDF. Check that the PDF holds them and that the scan is legible.
- A FEC that is not in the statutory format is refused for the trial balance. Select the trial balance in Excel instead.
Learn more
- Compare versions compares two versions of any document, line by line.
- Analytical review (GL) builds the statements from the ledger.
- Review and correct: the Preview, the ticks and the notes.