Check the numbers, prepare the mapping and make the workbook readable. Start with one task, then bring your own Excel or CSV files into the private workspace.
How to turn a trial balance into financial statements
You can start with a closing trial balance (TB) even when a transaction-level general ledger (GL) is unavailable. A TB supplies account totals; a GL also supplies the entries behind those totals. Choose the data source that matches your file instead of reshaping your workbook into an unfamiliar template.
Select the worksheet and header row. Reports often contain a title, reporting date and totals above the column headings. Select the actual headings, not the first row of the worksheet.
Map the columns. Identify the account code, account description and either a signed closing balance or separate debit and credit columns. If opening, movement and closing amounts all appear, choose the closing figures for the closing TB. Keep account codes as identifiers rather than amounts.
Check that the TB ties. Review total debits, total credits and the difference before proceeding. A balanced TB does not prove that account classification or transactions are correct. If it does not balance, investigate missing rows, incorrect columns, duplicated totals or sign conventions; do not insert an unexplained balancing amount.
Map accounts to financial statement line items. Create your own line items or import an Excel mapping. Local description-based suggestions are a starting point, not an accountant's conclusion. Review unfamiliar accounts and use the unmapped filter to find gaps.
Review the statements and export. Check presentation, classifications and linked notes. Adjust the statement layout for your reporting needs before exporting the linked Excel workbook.
Example: a debit balance of 1,250 and a credit balance of 250 produce a signed net debit balance of 1,000. Use one consistent convention across the entire import.
Why opening balances matter for cash flows
For an existing entity, upload and confirm a brought-forward opening balance sheet at the start of the reporting period. Prior-period profit or loss belongs in the relevant equity account, not in the current period's revenue and expense balances. Confirm genuinely zero opening balances only for a first reporting period when that is factually correct.
Opening and closing TBs show changes in balances, but cannot by themselves identify every non-cash movement. Cash-flow preparation may require adjustments and movement classifications. Direct cash flows need suitable cash-transaction data and reviewed classifications. A cash-flow reconciliation should explain the movement in cash, not force it to agree through a plug.
CloseSentry produces management drafts, not a complete statutory reporting package. Have the underlying balances, adjustments, classifications and disclosures reviewed by a qualified professional.
General ledger review before month-end close
A useful review is targeted: choose checks that match the business and the reporting period, then document why each exception is acceptable or needs correction. A flagged entry is a question to investigate, not evidence of fraud or a confirmed accounting error.
Confirm the import scope. Check the entity, period, currency, date column and amount columns. Reconcile imported totals to the source report and ensure summary rows have not been included as transactions.
Select relevant checks. Use the built-in review library and custom rules to focus the review. Thresholds should reflect your business rather than treating every large or round-number entry as wrong.
Investigate the source entry. Compare its description, account, amount and date with supporting records. A duplicate-looking transaction may be a legitimate recurring charge; an unusual posting may be a documented year-end adjustment.
Record the outcome. Add a review note, resolve genuine errors in the source accounting records or through properly supported adjustments, and retain the exported review evidence.
When only a TB is available, you can review balances and prepare drafts, but cannot perform transaction-level testing that depends on ledger detail. Request the GL for those checks rather than interpreting their absence as a clean result.
Format Excel financial statements for A4 printing
A workbook can calculate correctly and still print badly. Working columns, hidden rows, oversized tables and misplaced page breaks can make a polished statement difficult to read.
Choose only the sheets to format. Separate the published statements and notes from internal calculations or supporting schedules.
Inspect hidden rows and columns. Unhide them for review when appropriate. Do not assume every hidden item belongs in the final printed statements; preserve or exclude it deliberately.
Set the relevant print columns. Exclude grey working areas and other internal calculations without deleting the supporting data. Review the print area for each sheet.
Choose paper size and orientation. Use A4 and an orientation appropriate to the statement. Fit to the page width where useful, but avoid shrinking a long statement to one unreadable page.
Review spacing and page breaks. Keep headings with their detail and totals with their supporting lines. Use consistent number formats, note references, indentation and comparative column alignment.
Check the exported result. The browser preview is an estimate. Open the exported workbook in Excel and inspect its actual print preview before issuing a final PDF or printed set.
What well-presented notes need
Use numbered note headings, clear subheadings, consistent amount columns and totals that reconcile to the face statements. Supporting account detail is not a substitute for required accounting policies or narrative disclosures. Add the necessary entity-specific explanation; do not fill missing disclosures with generic text that may not apply.
Private files, clear limitations
CloseSentry's accounting tools process uploaded files in your browser. The current free beta does not require a payment checkout. Export your work before refreshing or closing the tab; do not rely on it as your accounting system or permanent archive.
The reporting workflow covers one entity and one functional currency. It does not provide currency conversion, consolidation, a complete comparative-year package, a statement of changes in equity or a complete statutory disclosure set. Description-based mapping suggestions are local rules, not a connected AI model.
Start with the sample data to learn the interface. Templates and the introductory tutorial are available in the workspace's Help & templates section.