Learn from some of the most innovative publishers in the industry.
An event focused on revenue and the future of publishing.

knowledge base

Answers & Best Practices

Utilizing MediaOS with QuickBooks Desktop

We understand that old habits die hard and some people prefer QuickBooks Desktop to QuickBooks Online. While we do not have a direct sync with QuickBooks Desktop due to the lack of online functionality, it’s easy to export information out of MediaOS and import into QuickBooks Desktop. This allows you to balance your books using the invoices and payments that you’re running through MediaOS rather than duplicating your entries in QuickBooks Desktop.

Exporting Your Invoices and Payments

Go to Accounting -> Invoices

From here, run a report for the invoices that you would like to export

Select Batch Action – Download as CSV

Follow this same process for Payments that you would like to export.

Importing Your CSV Into QuickBooks Desktop

Follow these steps to import CSV into QuickBooks Desktop:

1. Open your company file and then click the “File” menu.

2. From there, select “Import.”

3. Once the “Import” menu appears, choose the “Excel” option.

4. You can then choose the CSV file that you want to import.

Once the file is imported, you can select the columns in the spreadsheet to link to your general ledger accounts. This process can vary slightly based on the version of QuickBooks desktop you’re using, but it’s very similar across the board.

Skip to content