Summary: Import QuickBooks sales into Easy Royalties

Brief

Importing QuickBooks sales into royalty software is simple. Just export the sales from QuickBooks in Excel format. Then import the file into Easy Royalties. Easy Royalties sales import will automatically filter out any rows that are blank - such as subtotal rows and rows with no data.

Procedure

Step 1. Customize QuickBooks Sales by Item (Detail) Report

You need to customize the standard report via Modify Report to turn off the headings and footers.

Then add the additional fields that you you need.

Step 2. Memorize the customize report for future use

Step 3. Export the Sales Report into Microsoft Excel

When you select the export button, click the advanced tab and select send header to screen. This will place the field names in the first row of your Excel file.

Step 4. Import Sales file into Easy Royalties

Open Easy Royalties and go to File > Import > Sales

Then import your sales file.