Generating an Accounting Report

Part 1: Preview and Generate an Accounting Report.

1. From the dashboard, click "Reports" > "Accounting"

   

2. There are two sections: "Account Statement" and "Accounting Report." 

• Account Statement are transactions pertaining to your imago account.
• Accounting Report are transactions pertaining to your customer orders.

3. The Accounting Report will default to show the last 12 months. You can change this to any date range you need.

4. There is a preview of transactions for each Project that includes the number of orders and total retail amount for the selected time frame. 

5. Click "Request Full Report" to generate an Excel report containing details for each individual order. You can email a copy of the report if you prefer. 

6. Your report request will show in the section "Reports Requests in the last 24 hours." It may take a few minutes for the report to process, but will show an option to download once it is ready.

Part 2: Understanding the Report

The Summary by Project tab shows simplified details for each project: Project Name, Order Count, Gross Sales, Sales Tax, Net Sales, Costs (Excluding Sales Tax), Studio Payment, Credit Card Processing Fees, and Final Studio Revenue. A Grand total is shown on the last row. 

Gross Sales is total amount of revenue made before applying sales taxes. Net Sales is the total of revenue after applying sales taxes.

Costs are the sum of fees, excluding sales tax.

A more detailed breakdown of revenue and costs can be seen on the accounting tab.

The Payouts tab contains a summary of payouts: Batch Date, Gross Sales, Costs, Studio Payment, Credit Card Processing Fees, and the Studio Revenue:

The Summary Sale Tab breaks down the amount of sales made in each phase of the project. It includes the Project, and then the Presale, Late Presale, Proof Sale, Gallery Sale, and the Grand Total.

If a project did not include the sale type, it won’t show up in the report. If the project no sales during the specific period, it will show the field as $0.00.

The Accounting tab includes full details for each order

Columns A-F  contain Order details: Order ID, Order Date, Organization Name, Project Name, Sale Type, and Customer Name.

The Organization name fields will be blank, unless filled in by the studio on the Organization Page.

Columns G-R contain the Revenue Details: Sale Subtotal, any Shipping Costs, Additional Charges you have set up for the project, Promotion Discounts, Shipping Discounts, Net Sales, Sales Tax, and Gross Sales

Net Sales is the sum of all revenue fields, before the application of sales tax

Gross sales include the addition of sales taxes

Columns S-W contain Costs: Service Fee, Imago Fulfillment (if applicable), Shipping, Sales Tax, and the Gross Costs Total.

The Service Fee (Studio/Imago) is based on the percentage your studio pays based on your subscription, as well as the fulfillment type for the project.

The Imago fulfillment is the cost to produce the product ordered. If the studio fulfills the order, this should be 0$.

The Gross Costs Total is the sum of all costs in the section.

Columns X-AA contain Merchant Account information: Batch Date and Total Studio Payment.

The Batch Date is the day the payment was sent from Imago to the studio. The Studio Payment is the amount sent in the batch.

The Credit Card Processing fee is also charged as part of the Batch, resulting in the final Studio Revenue. Each Payment and Fee is combined with each other in the days’ batch. This means that all payments and fees sent on one date should be combined into a single payment and a single charge to the bank. This information can also be found on the Payouts Tab