Data
The General Ledger is your book of record. Everything else adds detail or checks it, in this order.
Where your data goes
One upload feeds every part it can.
| What is loaded | Financials | Sales | Expenses | Banking | Forecast |
|---|---|---|---|---|---|
Your accounts General Ledger, Trial Balance, P&L, PDF or Odoo Aug 2025 – Sep 2026 (14) | P&L, balance sheet, cash flow | sales by revenue account | costs by account | bank checks | starting point and trends |
Lines in your ledger each invoice and bill, with its date and partner Aug 2025 – Sep 2026 (14) | suppliers and checks | ||||
Sales file Aug 2025 – Sep 2026 (14) | customers, products, quantities |
How ready is your data?
Teal: what you have. Orange: how much of it checks out. Latest month: Sep 2026.
Financials
Data completeData accurate
Complete
77%
Accurate
100%
- Monthly P&L for the last 12 months100% complete · 100% accurate12 of the last 12 months have a P&L (Oct 2025 to Sep 2026).
- A balance sheet at every month end100% complete · 100% accurate12 of 12 months have a balance sheet; 12 of them balance.
- Opening balance sheet (the month before the first month)0% completeNone loaded: balances start from zero at Aug 2025. Upload opening balances if the company had balances before.What: Upload opening balances (the balance sheet at 31 Jul 2025).How: On the Opening balances card: Odoo's General Ledger or Trial Balance for that one day, or our template.
- Every month between the first and the latest100% completeNo missing months.
- The latest month is loaded60% completeLatest month: Sep 2026.What: Upload the months after Sep 2026.How: Odoo: Accounting → Reporting → General Ledger → Export. Or use our template.
- Cash flow explains the change in cash every month100% complete · 100% accurate12 of 12 months reconcile to the cent.
Sales
Data completeData accurate
Complete
100%
Accurate
100%
- Sales for every financial month100% complete12 of 12 financial months have sales lines.
- Monthly sales equal P&L revenue (within 1%)100% complete · 100% accurate12 of 12 months tie to revenue.
- Every sale has a customer100% complete100% of sales name the customer.
- Products have a category100% complete100% of sales have a product category.
- Quantities sold100% complete100% of sales have quantities.
- Cost of each sale (for margins)100% complete100% of sales have their cost.
Expenses
Data completeData accurate
Complete
94%
Accurate
100%
- Expense lines for every financial month100% complete12 of 12 financial months have expense lines.
- Monthly lines equal P&L costs (within 1%)100% complete · 100% accurate12 of 12 months tie to the P&L. P&L costs = cost of sales + expenses (variable, fixed, depreciation and amortisation) + other expenses + interest + tax.
- Payments name the supplier68% complete54% of spend names who was paid (salaries usually don't; 80% is plenty).What: Fill the Partner on bills and payments.How: In Odoo, set the Vendor on each bill. In our template, fill Supplier.
- Each line has a cost type100% complete100% of spend has a cost type (rent, salaries, materials…).
- The latest month has expense lines100% completeSep 2026 is in.
Inventory
Data completeData accurate
Complete
100%
Accurate
100%
- Stock valuation (the money)100% completeLoaded.
- Moves history (quantities and locations)100% completeLoaded.
- Stock on hand (the closing count)100% completeLoaded.
- Exported with Odoo's record IDs100% completeEvery record carries its Odoo ID: duplicates are refused exactly.
- Stock value equals the stock accounts100% complete · 100% accurate12 of 12 months agree.
- Each month's change in stock equals the accounts100% complete · 100% accurate12 of 12 months agree.
- Cost of goods delivered equals cost of sales in the accounts100% complete · 100% accurate12 of 12 months agree.
- Goods received and landed costs equal the stock postings100% complete · 100% accurate12 of 12 months agree.
- Rental moves carry no value100% complete · 100% accurate12 of 12 months agree.
- Odoo’s stock list equals the moves into the warehouses100% complete · 100% accurate1 of 1 month agree.
- Units valued equal the units the moves hold100% complete · 100% accurate1 of 1 month agree.
- Stock value equals warehouses + on rental + in transit100% complete · 100% accurate1 of 1 month agree.
Payments
Data completeData accurate
Complete
100%
Accurate
100%
- Aged Receivable, tied to the books100% complete · 100% accurateAs of 2026-09-30, 596,514 agrees with 121000 Trade Receivables.
- Aged Payable, tied to the books100% complete · 100% accurateAs of 2026-09-30, 282,734 agrees with 221000 Trade Payables.
- Customer and vendor payments100% complete48 payments loaded.
Banking
Data completeData accurate
Complete
60%
Accurate
100%
- Two years of months, or three audited years58% complete14 months loaded. Banks look at 2–3 years.What: Add earlier years.How: Upload each year's General Ledger, or audited statements (PDF works).
- Loan principal due in the next 12 months0% completeNot entered: debt service is estimated.
- Your borrowing rate100% complete24% a year.
- The loan you want to ask for0% completeNot entered.
- Inflation and exchange rates100% completeEntered.
- A balance sheet at every month end100% complete · 100% accurate12 of 12 months have a balance sheet; 12 of them balance.
Forecast
Data completeData accurate
Complete
67%
Accurate
–
- 12 or more consecutive months (24 for seasonality)100% complete14 consecutive months up to the latest.
- The latest month has a balance sheet100% completeStarts from Sep 2026.
- Forecast drivers reviewed and saved0% completeUsing the measured defaults; review growth, margin, days and loans.