Invoice Export Presets

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:

1. Go to Settings > Billing and click the Export Settings tab.
2. Click on the blue Add preset button in the top right corner of the screen.
3. 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 `,`.
4. After everything is set click Add.

To use the newly created preset follow the steps below:

1. Go to Billing > Invoices.
2. Select the invoices that need to be exported and click the Export icon in the top right corner of the screen.
3. In the Export Invoice Data tab click the checkbox next to Use an export preset.
4. From the dropdown menu choose the preset you created.
5. 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.