PlumHelp
Help · Revenue

Importing costs

Import a Profit and Loss by month from your accounting system so customer acquisition cost and gross margin come from the books. You say once what each ledger account is, and Plum remembers.

Owners, admins and revops

Export the report

In QuickBooks Online, go to Reports → Profit and Loss. Set the period, set Display columns by to Months, run the report and export it as CSV. Use a closed period where you can: what you import is what CAC and gross margin are calculated from.

Import it

  1. Go to Revenue → Unit economics and select Import costs.
  2. Choose the exported CSV file. Or open the export in Excel, select everything, copy, paste it into the box, and select Continue.
  3. Under Say what each account is, check the category for each ledger account. Plum guesses from the account's name and section, and your earlier choices win.
  4. Under Check the totals, compare the figures with the report in your accounting system.
  5. Select Import these costs.

The categories

Sales and marketing
What customer acquisition cost is worked out from.
Customer success
Support and account management. Kept separate and never counted in CAC.
Cost of revenue
What it costs to deliver. With revenue, it gives gross margin.
Revenue
Income lines, used only to work out gross margin.
Not counted
Stored, but used for nothing.

Importing again

An import replaces any costs already imported for the months the file covers. Other months are left as they are. To correct a month, export it again and import it. Your category choices are remembered for next time.

If it doesn't import

  • No column per month: run the report with Display columns by set to Months.
  • One cell isn't an amount: nothing was read. Check the cell Plum names.
  • Excel, Numbers or PDF files can't be read. Export as CSV, or copy and paste instead.
  • Two accounts with the same name in the same month: nothing was stored.

Only the rows shown in the preview are sent to Plum, and they are checked again when they arrive. An import either stores everything or nothing.

Related