In OfficeRnD you can make custom invoice export presets. You can set a date format and choose specific properties or columns. Follow the steps below to create an invoice export preset:
- Go to Settings > Billing and click the Export Settings tab.
- Click on the blue Add preset button in the top right corner of the screen.
- In the newly opened window add the following information:
- Name - this will be the title of the preset. You're going to be able to choose it from a dropdown menu in the Billing > Invoices > Export window.
- Columns - click on the "+" sign and select a column from the dropdown menu. After that type the title of the column and click the "+" sign again to add more columns. Find each property's meaning at the end of the article.
- Custom Date Format - type the preferred date format and divide the days (DD) months (MM) and year (YYYY) with a hyphen (-).
- Custom Line Numbering - here you can change the initial number of the LineNumber column. The LineNumber column adds alternative numbering for the exported items.
- Custom File Header - the additional head is going to be added before the exported content in the CSV file. To add more than one additional headers separate them with a `,`.
- After everything is set click Add.
To use the newly created preset follow the steps below:
- Go to Billing > Invoices.
- Select the invoices that need to be exported and click the Export icon in the top right corner of the screen.
- In the Export Invoice Data tab click the checkbox next to Use an export preset.
- From the dropdown menu choose the preset you created.
- Click Download Invoice Data.
Column Properties:
- Description - The description of every line item.
- ItemCode – Plan's unique code field (next to the Plan name in the Plan dialog).
- Quantity - Quantity of every line item in the invoice.
- Unit Price - The price per unit for the specified plan. If it's a monthly membership, this is the price per full month. You can leave it "Unit price" as it is an accounting term connected to the line item.
- Unit Price without tax - Depending on the tax strategy it could be the same as the unit price or the number on which you should apply the tax.
- Total without tax - The total amount of the invoice without the tax.
- Discount - Percent discount per line item, if a fee is paid partially with coins, the discount won’t be applied.
- Tax Rate Code – Tax percentage.
- Tax – Total tax amount.
- Line Total - Total amount of the line item in the invoice.
- Account Name – Revenue account name.
- Account Code – Unique code for revenue account.
- Tax Rate Code – Unique code for tax rate.
- Tax Rate Type – Name of the tax rate.
- Line Start Date – Membership period start date.
- Line End Date – Membership period end date.
- Line Start Month – Membership period start month.
- Document Type - Type of document in terms of “invoice”, “credit note”, “overpayment”.
- Invoice Number - Number of the invoice/credit/overpayment document.
- Reference – The information entered in the “reference” field of the invoice.
- Allocations – List of allocated credit notes or overpayments to invoices.
- Invoice Date – Issue date of the invoice.
- Due Date - Due date of the invoice.
- Payment Method – Payment method of the invoice – “Bank transfer”, “Cash”, etc.
- Pending Amount – Calculated the total amount of the invoice when the due date has not arrived yet.
- Paid Amount - Calculated the total amount of the invoice when the status is paid.
- Payable Amount - Calculated the total amount of the invoice when the status is overdue.
- Amount – Total amount of the invoice with tax.
- Base Total – Total amount of the invoice without tax.
- Start Date – Start of the common memberships start date.
- End Date - End of the common memberships end date.
- Charge Details – Details when there is a payment gateway integration.
- Invoice Month – Issue date month.
- Invoice Period Month - The period of which the invoice is generated for.
- Office Name – Name of the location.
- Office Code – Unique code of the location.
- Line Number – invoice line item numbers.
Comments
Please sign in to leave a comment.