Categorized Spend Report

Our Categorized Spend Report in the Reports dashboard of our Client Portal allows our Admin Users to pull all their Brilliant Invoice Spend Data across Projects, Storefronts, Preferred Gift Campaigns and Monthly Statement Invoices into a single report. Slice and dice your report by spend categories like product, shipping, fulfillment fees, taxes, credits and more.

To generate an Invoice Category Spend Report, click Generate Report. By default your data will filter to all data you have access to for the last 30 Days, but you can filter your data by the following elements:

• Source: Select whether you’d like to filter to Storefront Statements, Order Invoices, or both.

  • Storefront Statements are your monthly Statements for any Storefront or Project and typically include shipping, taxes and fulfillment fees for specific orders sent to given destinations for your project.

  • Order Invoices are Estimates that were approved by your Company that have been invoiced to you. These typically include the cost of physical goods, their decoration, and shipping to one of our warehouses or directly to a location of your choosing from our preferred vendors.

• Storefront: Select which Storefronts you’d like included with this data. Please note that all Project related Statement data for the time period you select will automatically be included in this report.

• Date Range: Choose from the following date range options: Last 7 Days, Last 30 Days, This Month, This Year, Last Year, All Time. This uses the Sent Date for your Statement or Invoice.

  • Brilliant’s data ranges work on calendar quarters and years We do not allow filtering by custom date ranges at this time.

Clicking Generate Report will begin generating your report behind the scenes and Brilliant will automatically email your report directly to your user email. Keep an eye out for an email with the subject ‘[BRILLIANT] Your file is ready!’ that will contain a .csv file ready for downloading and viewing.

Each line on the report is a Spend Category related to a given Statement or Invoice for your account. The Spend Categories we break down your Statements and Invoices into are:

• Product: Charges for your physical product, eGifts and On Demand items. Our Product spend category has the following detailed sub-categories:

  • Physical Product: Typically your physical goods made for your Brilliant programs, but can also include On Demand and eGift sends.

  • Discount: Any discount provided by Brilliant to you for your Products. These will show as credits.

  • Prepayment: Prepayments you have sent Brilliant to be set aside for future invoices.

  • Split Fee: This fee is occasionally incurred to cover things like splitting a direct shipment from a vendor to multiple drop ship locations, or to split bulk orders of physical product across multiple invoices. For more details, review your associated invoice or statement.

  • Misc Brilliant Services: Covers other charges related to the creation of your physical goods. For more details, review your associated invoice or statement.

  • Uncategorized Products: Catch all for line items that may not fit into the above sub-categories. For more details, review your associated invoice or statement.

• Shipping: Charges related to shipping items for your Brilliant gifting programs. Our Shipping spend category has the following detailed sub-categories:

  • Shipping: Shipping charges for getting your physical goods to a Brilliant warehouse or for direct shipping from our vendors to your desired final destination.

  • Store Order Shipping: Shipping charges for individual orders sent to recipients for your programs, generated from batch orders created by a drop ship list or our Storefront or Preferred Gift Campaign platform solutions.

  • Customs Charges (VAT & Duties): VAT & Duties fees from shipping items across countries.

  • Customs Charges (Other): Other customs related charges incurred from shipping items across countries.

• Fulfillment: Charges related to the fulfillment of your goods in Brilliant’s warehouse - including storage fees, pick and pack fees, special handling fees, and more. Our Fulfillment spend category has the following detailed sub-categories:

  • Storage Fees: Monthly charge for inventory held in a Brilliant warehouse.

  • Intake Fees: Charges for third party inventory being sent to and stored in a Brilliant warehouse.

  • Pick and Pack Fees: Our standard fees to pick and pack your orders for project based fulfillment. This is often for Kit & Fulfill projects sent to one location.

  • Store Order Pick and Pack Fees: Our standard fees to pick and pack Store Orders, generated from batch orders created by a drop ship list or our Storefront or Preferred Gift Campaign platform solutions. .

• Taxes: Sales Tax applied to invoices or Store Orders. Our Taxes spend category has the following detailed sub-categories:

  • Sales Tax: Sales tax charges incurred for your projects.

  • Store Order Sales Tax: Sales tax charges incurred for Store Orders, generated from batch orders created by a drop ship list or our Storefront or Preferred Gift Campaign platform solutions.

• Platform: Charges related to our technology platform - including fees for the use of our Storefront, Preferred Gift Campaign and Automations & Integrations. Our Platform spend category has the following detailed sub-categories:

  • Storefront - Set Up Fee: Initial fee to set up your Storefront.

  • Storefront - Subscription Fee: Recurring fee, typically annually or monthly, to utilize our Storefront solution.

  • Preferred Gift Campaign - Set Up Fee: Initial fee to set up your Preferred Gift Campaign.

  • Preferred Gift Campaign - Subscription Fee: Recurring fee, typically monthly, to utilize our Preferred Gift Campaign solution.

  • Correction: Correction to your Platform fee on a given statement, typically shown as a credit.

  • Misc Billing Charges: Catch all for any other technology platform related charges to your account.

• Transaction Fee: Fees related to processing payments or eGift cards for your orders and invoices. Our Transaction Fee spend category has the following detailed sub-categories:

  • Credit Card Processing Fee: Fees incurred for processing credit card payments at Storefront checkout for users.

  • eGift Processing Fee: Fees incurred for issuing eGifts to recipients.

  • Transaction Fee: Fees incurred for processing credit card or other payment types on invoices and statements.

• Credits: Credits issued on your monthly Statement or Custom Order Invoice. Our Credit spend category has the following detailed sub-categories:

  • Customer Deposit Credit: Credit for a deposit made to Brilliant.

  • Credit (Courtesy / Internal): Credit made by Brilliant, often due to rare issues that incur during product fulfillment.

  • Credit (Overpayment): Credit for overpayment.

  • Credit (Prepayment): Credit when Brilliant applies a prepayment made previously to a new invoice.

This report has the following columns:

• Invoice ID: This will show as the ID for your Invoice or Statement

• Type: This will show the Invoice, Statement as Statement

• Description: For rows that represent spend from Order Invoices for your Custom Orders of physical products, this will show the name of your custom order. For rows that represent spend from monthly Statements, this will show as ‘Store Statement’.

• Status: Payment status of the Order Invoice or Statement. This will show as one of the following statuses:

  • Invoiced: We’ve sent you the invoice but it has not been paid yet.

  • Paid: Invoice has been paid.

  • Canceled: We’ve canceled the invoice.

• Store Name: The Storefront name or Project / Custom Order Invoice name.

• Invoice Sent At: Date the invoice was sent to you.

• Payment Due Date: Date your payment is due to Brilliant.

• Paid Date: Date the Custom Order Invoice or Statement was paid.

• Category Group: The high level Category Spend group - Product, Shipping, Fulfillment, Taxes, Platform, Transaction Fee, or Credits.

• Category Detail: The detailed sub-category of spend. This should provide you with more detail to further breakdown and understand your Category Group level spend.

• Amount: The amount spent for this Group and Detail on this given Custom Order Invoice or Monthly Statement.

• PO Number: PO Number associated with this spend.

• Requesting User Email: The email address for the user who requested this spend from Brilliant. For Storefront statements, this is the first Store Admin added to the Storefront.

• Approver: For Custom Order Invoices, the user who approved the Estimate.

• Approval Date: For Custom Order Invoices, the date the Estimate was approved.

• Bill To User: The name of the user who receives the invoice.

• Invoice URL: This is a link to the Custom Order Invoice or monthly Statement in Brilliant’s client dashboard, allowing you to easily drill into specific invoices for further review directly from your report.