Studio Manager makes it easy to keep track of your invoice payments. If you want an overview of your past transactions or need to report taxes, you can take advantage of the Export option in your Payments page. This article will go over how to export your invoice payments and outline the data covered.
Note: Pixieset does not file any taxes or remit any tax payments on your behalf. If you have questions about collecting or reporting taxes, you should consult with a local tax advisor as Pixieset does not provide advice regarding requirements applicable to your business.
On this page
Exporting your Invoice Payments
To export your payment activity, go to Studio Manager Dashboard > Payments, and click Export in the top right hand corner.
This will compile all your invoices’ transactions into a CSV file download, which you can download and open with your computer’s spreadsheet software (e.g. Excel).
Understanding your Payments Report
Your CSV file will automatically organize details for your invoice payments across important columns:
- Client Name: The full name of the client assigned to the invoice (e.g. Jane Smith).
- Client Email: The client’s email address (e.g. email@example.com).
- Invoice #: The invoice number associated with the specific transaction (e.g. 1005).
- Type: The type of transaction. This will be either “Payment” or “Refund”.
- Payment Method: The name of the payment method for the transaction (e.g. Credit Card, Cash, etc.).
- Refunded Amount: The transaction’s refunded amount. If the transaction is a payment rather than a refund, the amount displayed will be 0.00.
- Total Amount Paid: The transaction’s paid amount. If the transaction is a refund rather than a payment, the amount displayed will be 0.00. This is calculated as follows: Taxable Amount + Tax Amount + Non Taxable Amount = Total Amount Paid.
- Transaction Fee: Stripe’s processing fee for applicable credit card and bank transfer (ACH) transactions.
- Net Amount: The total amount paid, after Stripe’s transaction fee is deducted.
- Tax Percent: Your combined tax rate from the associated invoice (e.g. 5% GST and 7% PST would be displayed as 12%).
- Tax Amount: The transaction’s total tax amount paid.
- Taxable Amount: The transaction’s amount that is taxable.
- Non Taxable Amount: The transaction’s amount that is associated with a non-taxable item.
- Charge Date: The transaction date (i.e. DD/MM/YYYY).
- Tip: The tipped amount in the transaction.
- Discount: The discount amount/percentage set on the associated invoice.
- Discount Amount: The discount for the payment transaction. This is calculated as follows: Payment Amount x Invoice Discount Amount ÷ Invoice Total = Discount Amount
- Currency: The currency of the transaction’s associated invoice (e.g. USD).