Accounting
BTCPay Server offers several tools that make bookkeeping easier.
Invoice Export
To export the invoices:
Go to
Invoices
.Click on
Export invoices
.Select the export format (CSV/JSON) and download the file.
You can then customize the fields to fit your business needs and import the data into your accounting software, or create pivot tables from the exported data.
The fields are the following:
Field name | Description |
---|---|
ReceivedDate | Date the payment has been received |
StoreId | The store receiving the payment |
OrderId | The order Id of the invoice |
InvoiceId | The invoice ID |
InvoiceCreatedDate | Date of creation of the invoice |
InvoiceExpirationDate | Date of expiration of the invoice |
InvoiceMonitoringDate | Date your BTCPay Server ceases to monitor events of the invoice |
PaymentId | Unique identifier of a payment |
Destination | The destination address the customer paid to |
PaymentType | The type of payment ( |
CryptoCode | Currency code of the method of payment (e.g. |
Paid | Amount paid in the currency defined in CryptoCode |
NetworkFee | Network fee paid by the user in this payment |
ConvertionRate | The conversion rate at the time of invoice creation between |
InvoiceCurrency | The currency code of the invoice (e.g. |
InvoiceDue | The amount still due to fully pay the invoice after this payment (minus |
InvoicePrice | The total price of the invoice (minus Network Fee, denominated in |
InvoiceItemCode | The item code afferent to the products/services billed by the invoice |
InvoiceItemDesc | The item description afferent to the products/services billed by the invoice |
InvoiceFullStatus | The full status of the invoice (e.g. |
InvoiceStatus | The simplified status of the invoice (e.g. |
InvoiceException | The status of the invoice (e.g. |
QuickBooks Online Connector for BTCPay Server
BTCQBO is a third-party plugin that enables QuickBooks Online users to connect their BTCPay Server easily. Besides bookkeeping, users can quickly generate invoices from their QuickBooks. For more information about the BTCQBO and all the features it offers, check the plugin repository.
Last updated