QuickBooks Online forecasting and FP&A

What comes in from QuickBooks

Timshal imports your Profit and Loss and Balance Sheet as monthly figures, one line per account, keeping the account names and the folder structure you use in QuickBooks, including QuickBooks' own total rows. Each QuickBooks company is its own data source, so a group with several entities connects each one.

• Profit and Loss and Balance Sheet accounts, by month
• Optional breakdowns by Class, Location, Customer or Vendor, which become dimensions you can forecast by
• Drill-down from any P&L figure to the transactions behind it
• Up to three years of monthly history on each sync

It reads, it never writes

You connect QuickBooks through Intuit's own sign-in window. Timshal only reads your reports; it never writes to your books.

From actuals to a forecast

Once your accounts are in, you decide how each line should be forecast. Revenue might come from customers times price, payroll from your headcount plan, and rent from a fixed monthly amount. Actuals fill the closed months and your drivers fill the future, in the same model.

Because the model is dimensional, a breakdown such as Class or Location is not a pile of copied rows. You write the forecast logic once, and it applies to every class or location, including new ones that appear in QuickBooks later.

Keeping actuals current

Set the connection to sync daily, weekly or monthly, or press Sync Now whenever you have closed a month. Each sync refreshes the actuals, while your forecast assumptions stay as you left them.

Budget vs. actuals without the export

With your plan and your QuickBooks actuals in one place, a dashboard table can show budget, actual and variance side by side for every account, and a click on a P&L number shows the transactions that make it up.