dozo
Menu

Profit and loss statement

Drop the CSV your bank lets you download, check the categories, and get a profit and loss statement as a PDF. Your bank data stays on your device.

DateDescriptionAmountCategory

Your files never leave your device. Everything happens in this browser tab. Nothing is uploaded, and closing the tab erases it.

How it works

  1. In your bank's website or app, export the transactions for the period as CSV (sometimes called Excel or spreadsheet export).
  2. Drop the file here. Each line is sorted into a category from its description; change any that are wrong, and the same payee changes everywhere.
  3. Check the totals, then download the profit and loss statement as a PDF, or the sorted lines as a CSV for your accountant.

Questions

Is my bank data uploaded?

No. The file is read in your browser, on your device. Nothing is sent anywhere, and the lines are remembered in this browser only so you can come back to them.

Which banks does it work with?

Any bank that exports CSV: it finds the date, the description and either one amount column or separate money in and money out columns, with US or European dates and numbers. A PDF statement can be turned into a spreadsheet first with Dozo's PDF to Excel.

What is a profit and loss statement?

A one-page summary of a period: sales, minus the cost of what you sold (gross profit and its margin), minus running costs by category (operating expenses), plus any other income: the net profit or loss and its margin. Lenders, landlords and accountants ask for it; self-employed people use it for their tax return.

Is it cash or accrual basis?

Cash basis: it counts money when it moved in or out of the account, as on your bank statement. Unpaid invoices and bills don't appear until they are paid.

What about transfers between my own accounts?

Lines that look like transfers, card bill payments or owner draws are left out of the statement, under Not business. Move any line in or out by changing its category.

Can I add cash I received?

Yes. Add a line with the date, a description and the amount (negative for money out) and pick its category.

Does it replace an accountant?

No. It gives a clear first draft of your numbers. Categories for taxes depend on your country and situation.

More free tools