Difference between revisions of "Category:Invoice"
| (72 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
[[Category:Guest Management]] | [[Category:Guest Management]] | ||
| − | This page is about the menu SETTINGS->GUEST MANAGEMENT-> | + | <div class="heading">Invoicing</div> |
| + | This page is about the menu SETTINGS->GUEST MANAGEMENT->INVOICING | ||
__TOC__ | __TOC__ | ||
| + | Invoices can be generated from the "Invoice" tab of the booking. | ||
| + | |||
== Invoice Content == | == Invoice Content == | ||
| + | |||
===Invoice Description=== | ===Invoice Description=== | ||
| + | The "Invoice Description" will be included on guest invoices you create. HTML commands can be used to add style and format to your message. [[Template Variables]] can be used to personalise the invoice. | ||
| − | + | This [[Customise_Invoice_Template|help page]] offers further instructions. | |
| + | |||
| + | If you want to make custom additions to invoices you can set up an internal custom question in {{#fas:cog}} (SETTINGS) > PROPERTIES > BOOKING QUESTIONS which you add to the invoice [https://wiki.beds24.com/index.php/Template_Variables#Content_from_.22Details.22_tab here] | ||
===Invoice Charges=== | ===Invoice Charges=== | ||
Items defined as "Invoice charges" will appear in a selector list on the booking invoice for easily adding a pre-set charge to a booking. These are internal invoice items which can be added from the control panel, they do not show on the booking page. After they have been set up they are available under "Charges" in a drop-down list in the "Invoice and Charges" tab of the booking. | Items defined as "Invoice charges" will appear in a selector list on the booking invoice for easily adding a pre-set charge to a booking. These are internal invoice items which can be added from the control panel, they do not show on the booking page. After they have been set up they are available under "Charges" in a drop-down list in the "Invoice and Charges" tab of the booking. | ||
| + | |||
| + | [[Template Variables|Template Variables]] can be used to display invoice charges in invoices, booking templates or Email templates. | ||
===Invoice Number=== | ===Invoice Number=== | ||
| − | To assign a unique consecutive invoice number open the booking and click on "Assign Invoice Number" in the "Invoice" tab of the booking. Invoice numbers are generated per account or sub account. If you have multiple properties and need invoice numbers for each property you can use [[:Category:Sub_Account|sub accounts]]. The default number is 1. A different "Next Invoice Number" can be set in SETTINGS-> | + | To assign a unique consecutive invoice number open the booking and click on "Assign Invoice Number" in the "Invoice" tab of the booking. Invoice numbers are generated per account or sub account. If you have multiple properties or a group of properties and need invoice numbers for each property you can use [[:Category:Sub_Account|sub accounts]]. The default number is 1. A different "Next Invoice Number" can be set in {{#fas:cog}} (SETTINGS) ACCOUNT->PREFERENCES. |
| + | |||
| + | Under REPORTS->CUSTOM REPORTS you can create individual reports. If you add the "Assign Invoice Number" column, you will have buttons which you can click to perform this action. | ||
| + | |||
| + | If you want to automatically assign invoice numbers you can set up an Auto Action in {{#fas:cog}} (SETTINGS) GUEST MANAGEMENT-AUTO ACTIONS. A template is available which you can further customize. Use the context help (?Icons) in the Auto Action and on the help page (click on HELP in the top right menu) for further instructions. | ||
| + | |||
| + | ====Search for Invoice Number==== | ||
| + | *You can use the Standard Report 'Invoice Numbers' to show a list of invoices. Now you can make a browser search for the invoice number. | ||
| + | |||
| + | *You can create a Custom Report at REPORTS > Custom Report.<br>Select the dates. (Ensure you select dates far enough in the past so you will see the data.) Under 'Show Columns', select various columns, including 'Booking Ref' and 'Invoice Number'. Then click refresh and you should be able to search for the Invoice number. You can add this custom report to your Dashboard. | ||
===Invoice Date=== | ===Invoice Date=== | ||
| Line 17: | Line 35: | ||
===Invoice Status=== | ===Invoice Status=== | ||
| − | The "Status" field in the "Charges and Payments" tab of the booking | + | The "Status" field in the "Charges and Payments" tab can be used to specify the type of item. Examples are payment methods or different VAT levels. Status can be preset for upsell items and for extra invoice charges. For details please use the context helps (? icons) in "Invoice Items" and "Uselling". |
| + | |||
| + | [INVOICETABLEPART:status1,status2,!status4] - Invoice table showing only items with matching status.The status items can be a comma separated list. To exclude status items prefix them with an exclamation mark, for example !status1. / | ||
| + | |||
| + | These template variables get the totals based on the status value in the booking: | ||
| + | |||
| + | [INVOICEPARTCHARGES:] | ||
| + | |||
| + | [INVOICEPARTPAYMENTS:] | ||
| + | |||
| + | [INVOICEPARTBALANCE:] | ||
| + | |||
| + | Add the status after the : Multiple status can be added separated by a comma. You can also apply an optional multiplier or offset. | ||
| + | |||
| + | You can include status values or exclude them with an exclamation mark ! | ||
| + | |||
| + | Example: A property uses 3 status which are tax, restaurant and bar | ||
| + | |||
| + | [INVOICEPARTCHARGES:restaurant,bar!tax:10%] will calculate the balance of all invoice charges with the status bar or restaurant but not tax and and apply a 10% offset. | ||
===Custom Invoice Balance=== | ===Custom Invoice Balance=== | ||
| − | You can calculate an invoice balance only for certain upsell items or exclude upsell items from being added to the invoice balance. If you want to use this functionality you will need to add a status to the upsell item ( in SETTINGS | + | You can calculate an invoice balance only for certain upsell items or exclude upsell items from being added to the invoice balance. If you want to use this functionality you will need to add a status to the upsell item ( in {{#fas:cog}} (SETTINGS) BOOKING ENGINE->UPSELL ITEMS). |
To set the status field of the invoice item include a pipe symbol | between the description text and the status text. For example Description of item | Status | To set the status field of the invoice item include a pipe symbol | between the description text and the status text. For example Description of item | Status | ||
| − | ==Invoice table display== | + | ===Invoice table display=== |
By default the invoice contains the template variable [INVOICETABLE]. Various other [[Template Variables|template variables]] displaying different content are available. | By default the invoice contains the template variable [INVOICETABLE]. Various other [[Template Variables|template variables]] displaying different content are available. | ||
<embedvideo service="youtube">https://www.youtube.com/watch?v=wZr1_j7PJ0I</embedvideo> | <embedvideo service="youtube">https://www.youtube.com/watch?v=wZr1_j7PJ0I</embedvideo> | ||
| + | |||
| + | <span style="color:#019cde; font-size: 150%;“ >{{#fas:info-circle}} </span> As a service to the guest the content of the confirmation table and invoice table will always use the guests language even if it is not supported. | ||
| + | |||
| + | ==Lock invoices / Multiple Invoices== | ||
| + | Lock invoices to prevent changes once an invoice number is assigned. The items will be removed from "Charges and Payments". When new invoice items are added the system will automatically start a new invoice. | ||
| + | |||
| + | You can activate this function in {{#fas:cog}} (SETTINGS) ACCOUNT->PREFERENCES. | ||
| + | |||
| + | <span style="color:#fe746c;“ >{{#fas:exclamation-triangle}} </span> If you have a booking with a locked invoice you will not be able to delete the booking. | ||
| + | |||
| + | ==Credit Invoice== | ||
| + | *Go to {{#fas:cog}} (SETTINGS) ACCOUNT->PREFERENCES and set "Lock Invoices" = Yes. | ||
| + | *Close the invoice you want to credit. | ||
| + | *Go to "Charges and Payments" and enter negative values for the items you want to credit. | ||
| + | |||
| + | If required you can set up a different invoice template in {{#fas:cog}} (SETTINGS) GUEST MANAGEMENT->INVOICE. You can select which template is used after you have clicked on "Printable Invoice". | ||
| + | |||
| + | ==Cancel Invoice== | ||
| + | *Go to {{#fas:cog}} (SETTINGS) ACCOUNT->PREFERENCES and set "Lock Invoices" = Yes. | ||
| + | *Lock the invoice you want to cancel. | ||
| + | *Go to "Charges and Payments" and enter the cancelled amount as a negative value to zero the balance. | ||
| + | |||
| + | If required you can set up a different invoice template for cancellations in {{#fas:cog}} (SETTINGS) GUEST MANAGEMENT -> INVOICES. You can choose the template after you clicked on "Print Invoice". | ||
| + | |||
| + | ==Different Invoice Address== | ||
| + | 1. Go to {{#fas:cog}} (SETTINGS) PROPERTIES->BOOKING QUESTIONS and set up "Custom Questions" for the information you need. If you do not want to show them on the booking page set them to "internal". | ||
| + | |||
| + | 2. Use template variables (i.e. [GUESTCUSTOMQ1], [GUESTCUSTOMQ2] ..) to add the information to your invoice template. | ||
| + | |||
| + | If you need a separate invoice template you can use one of the print templates ({{#fas:cog}} (SETTINGS) GUEST MANAGEMENT->INVOICING). | ||
== Currencies == | == Currencies == | ||
| Line 34: | Line 100: | ||
Example: [INVOICETABLE:1.1$] multiplies your prices by 1.1 (+10%) and displays them with a $symbol at the end. | Example: [INVOICETABLE:1.1$] multiplies your prices by 1.1 (+10%) and displays them with a $symbol at the end. | ||
| − | <embedvideo service="youtube">https://www.youtube.com/watch?v= | + | <embedvideo service="youtube">https://youtu.be/_vrcWnqVpNU</embedvideo> |
| + | |||
| + | |||
| + | You can use the "Status" field in the "Charges and Payments" tab of the booking if you need to record additional information i.e. a second currency or a conversion rate. You can use a template variable like STA in the custom invoice table or [INVOICETABLE2] to show the information from the status field. | ||
| + | |||
| + | For more information on currencies see [[Set_Currency|here]]. | ||
| + | |||
| + | ==Smart template variables == | ||
| + | Smart template variables can be used to automatically calculate from the values in the booking. | ||
| + | |||
| + | <embedvideo service="youtube">https://www.youtube.com/watch?v=GTAOOdEKxfY</embedvideo> | ||
| + | ==Extras Sold on Site == | ||
| + | You can set up internal "Invoice Items" which can be added from the control panel, they do not show on the booking page. After they have been set up they are available under "Charges" in a drop-down list in the "Invoice and Charges" tab of the booking. | ||
| − | + | ==OTAs / Channel Collect == | |
| + | Under SETTINGS-CHANNEL MANAGER you can set whether channel Collect payments are imported. When you import, the amount you pay to the OTA will be sent, not the amount the guest has paid. The guest has received the bill from OTA, so you do not have to charge the room charge. | ||
| − | + | If you need a different invoice template for certain channels you can set this in the channel manger settings (currently for selected channel only). See the channels help page for details. | |
| − | == Export/Import Data == | + | == Export/Import Data, Reports == |
Invoice data can be exported to a .csv file [https://api.beds24.com/csv/getinvoicescsv here]. If required data can be changed and uploaded [https://api.beds24.com/csv/putinvoicescsv here]. | Invoice data can be exported to a .csv file [https://api.beds24.com/csv/getinvoicescsv here]. If required data can be changed and uploaded [https://api.beds24.com/csv/putinvoicescsv here]. | ||
| − | |||
Monthly Invoice Revenue can be generated in the menu REPORTS->STANDARD REPORTS. | Monthly Invoice Revenue can be generated in the menu REPORTS->STANDARD REPORTS. | ||
| − | + | Under REPORTS-CUSTOM REPORTS you can create individual reports. If you add the "Print Invoice" or "Assign Invoice Number" columns, you will have buttons which you can click to perform this action. | |
| + | |||
| + | == Separate invoices for agents, business travellers, certain OTAs == | ||
| + | See [[Invoicees|this help page]] for more information. | ||
| + | |||
| + | == Send Invoice via Email == | ||
| + | To send an invoice as a pdf attachment via Email go to {{#fas:cog}} (SETTINGS) GUEST MANAGEMENT->AUTO ACTIONS and set up an Auto Action Email. A template is available which you can further customize. Use the context help (?Icons) in the Auto Action and on the help page (click on HELP in the top right menu) for further instructions. | ||
| + | |||
| + | If you send Emails with pdf attachment (invoice, booking template) to Alias-Email addresses from channels the cannel might filter the attachment out so it is not delivered to the guest. | ||
| + | |||
| + | == Accounting Software == | ||
| + | Beds24 integrates with [[Xero]], [[Kashflow.com|Kashflow]] and [[[sevDesk]],. If you want to use another system you can use [[Make]] to set up an integration or use the data export function (see above) to download data you want to import into your accounting software. | ||
| + | |||
| + | == Troubleshooting == | ||
| + | *If you can no longer edit content, read this help document: [[Corrupted_Content|Corrupted Content]] | ||
Latest revision as of 20:59, 9 February 2024
This page is about the menu SETTINGS->GUEST MANAGEMENT->INVOICING
Contents
- 1 Invoice Content
- 2 Lock invoices / Multiple Invoices
- 3 Credit Invoice
- 4 Cancel Invoice
- 5 Different Invoice Address
- 6 Currencies
- 7 Smart template variables
- 8 Extras Sold on Site
- 9 OTAs / Channel Collect
- 10 Export/Import Data, Reports
- 11 Separate invoices for agents, business travellers, certain OTAs
- 12 Send Invoice via Email
- 13 Accounting Software
- 14 Troubleshooting
Invoices can be generated from the "Invoice" tab of the booking.
1 Invoice Content
1.1 Invoice Description
The "Invoice Description" will be included on guest invoices you create. HTML commands can be used to add style and format to your message. Template Variables can be used to personalise the invoice.
This help page offers further instructions.
If you want to make custom additions to invoices you can set up an internal custom question in (SETTINGS) > PROPERTIES > BOOKING QUESTIONS which you add to the invoice here
1.2 Invoice Charges
Items defined as "Invoice charges" will appear in a selector list on the booking invoice for easily adding a pre-set charge to a booking. These are internal invoice items which can be added from the control panel, they do not show on the booking page. After they have been set up they are available under "Charges" in a drop-down list in the "Invoice and Charges" tab of the booking.
Template Variables can be used to display invoice charges in invoices, booking templates or Email templates.
1.3 Invoice Number
To assign a unique consecutive invoice number open the booking and click on "Assign Invoice Number" in the "Invoice" tab of the booking. Invoice numbers are generated per account or sub account. If you have multiple properties or a group of properties and need invoice numbers for each property you can use sub accounts. The default number is 1. A different "Next Invoice Number" can be set in (SETTINGS) ACCOUNT->PREFERENCES.
Under REPORTS->CUSTOM REPORTS you can create individual reports. If you add the "Assign Invoice Number" column, you will have buttons which you can click to perform this action.
If you want to automatically assign invoice numbers you can set up an Auto Action in (SETTINGS) GUEST MANAGEMENT-AUTO ACTIONS. A template is available which you can further customize. Use the context help (?Icons) in the Auto Action and on the help page (click on HELP in the top right menu) for further instructions.
1.3.1 Search for Invoice Number
- You can use the Standard Report 'Invoice Numbers' to show a list of invoices. Now you can make a browser search for the invoice number.
- You can create a Custom Report at REPORTS > Custom Report.
Select the dates. (Ensure you select dates far enough in the past so you will see the data.) Under 'Show Columns', select various columns, including 'Booking Ref' and 'Invoice Number'. Then click refresh and you should be able to search for the Invoice number. You can add this custom report to your Dashboard.
1.4 Invoice Date
When an invoice number is assigned the system will use the date the invoice number was assigned as invoice date.
1.5 Invoice Status
The "Status" field in the "Charges and Payments" tab can be used to specify the type of item. Examples are payment methods or different VAT levels. Status can be preset for upsell items and for extra invoice charges. For details please use the context helps (? icons) in "Invoice Items" and "Uselling".
[INVOICETABLEPART:status1,status2,!status4] - Invoice table showing only items with matching status.The status items can be a comma separated list. To exclude status items prefix them with an exclamation mark, for example !status1. /
These template variables get the totals based on the status value in the booking:
[INVOICEPARTCHARGES:]
[INVOICEPARTPAYMENTS:]
[INVOICEPARTBALANCE:]
Add the status after the : Multiple status can be added separated by a comma. You can also apply an optional multiplier or offset.
You can include status values or exclude them with an exclamation mark !
Example: A property uses 3 status which are tax, restaurant and bar
[INVOICEPARTCHARGES:restaurant,bar!tax:10%] will calculate the balance of all invoice charges with the status bar or restaurant but not tax and and apply a 10% offset.
1.6 Custom Invoice Balance
You can calculate an invoice balance only for certain upsell items or exclude upsell items from being added to the invoice balance. If you want to use this functionality you will need to add a status to the upsell item ( in (SETTINGS) BOOKING ENGINE->UPSELL ITEMS).
To set the status field of the invoice item include a pipe symbol | between the description text and the status text. For example Description of item | Status
1.7 Invoice table display
By default the invoice contains the template variable [INVOICETABLE]. Various other template variables displaying different content are available.
As a service to the guest the content of the confirmation table and invoice table will always use the guests language even if it is not supported.
2 Lock invoices / Multiple Invoices
Lock invoices to prevent changes once an invoice number is assigned. The items will be removed from "Charges and Payments". When new invoice items are added the system will automatically start a new invoice.
You can activate this function in (SETTINGS) ACCOUNT->PREFERENCES.
If you have a booking with a locked invoice you will not be able to delete the booking.
3 Credit Invoice
- Go to (SETTINGS) ACCOUNT->PREFERENCES and set "Lock Invoices" = Yes.
- Close the invoice you want to credit.
- Go to "Charges and Payments" and enter negative values for the items you want to credit.
If required you can set up a different invoice template in (SETTINGS) GUEST MANAGEMENT->INVOICE. You can select which template is used after you have clicked on "Printable Invoice".
4 Cancel Invoice
- Go to (SETTINGS) ACCOUNT->PREFERENCES and set "Lock Invoices" = Yes.
- Lock the invoice you want to cancel.
- Go to "Charges and Payments" and enter the cancelled amount as a negative value to zero the balance.
If required you can set up a different invoice template for cancellations in (SETTINGS) GUEST MANAGEMENT -> INVOICES. You can choose the template after you clicked on "Print Invoice".
5 Different Invoice Address
1. Go to (SETTINGS) PROPERTIES->BOOKING QUESTIONS and set up "Custom Questions" for the information you need. If you do not want to show them on the booking page set them to "internal".
2. Use template variables (i.e. [GUESTCUSTOMQ1], [GUESTCUSTOMQ2] ..) to add the information to your invoice template.
If you need a separate invoice template you can use one of the print templates ( (SETTINGS) GUEST MANAGEMENT->INVOICING).
6 Currencies
Smart template variables are available to auto convert the values from the booking into another currency.
Example: [INVOICETABLE:1.1$] multiplies your prices by 1.1 (+10%) and displays them with a $symbol at the end.
You can use the "Status" field in the "Charges and Payments" tab of the booking if you need to record additional information i.e. a second currency or a conversion rate. You can use a template variable like STA in the custom invoice table or [INVOICETABLE2] to show the information from the status field.
For more information on currencies see here.
7 Smart template variables
Smart template variables can be used to automatically calculate from the values in the booking.
8 Extras Sold on Site
You can set up internal "Invoice Items" which can be added from the control panel, they do not show on the booking page. After they have been set up they are available under "Charges" in a drop-down list in the "Invoice and Charges" tab of the booking.
9 OTAs / Channel Collect
Under SETTINGS-CHANNEL MANAGER you can set whether channel Collect payments are imported. When you import, the amount you pay to the OTA will be sent, not the amount the guest has paid. The guest has received the bill from OTA, so you do not have to charge the room charge.
If you need a different invoice template for certain channels you can set this in the channel manger settings (currently for selected channel only). See the channels help page for details.
10 Export/Import Data, Reports
Invoice data can be exported to a .csv file here. If required data can be changed and uploaded here.
Monthly Invoice Revenue can be generated in the menu REPORTS->STANDARD REPORTS.
Under REPORTS-CUSTOM REPORTS you can create individual reports. If you add the "Print Invoice" or "Assign Invoice Number" columns, you will have buttons which you can click to perform this action.
11 Separate invoices for agents, business travellers, certain OTAs
See this help page for more information.
12 Send Invoice via Email
To send an invoice as a pdf attachment via Email go to (SETTINGS) GUEST MANAGEMENT->AUTO ACTIONS and set up an Auto Action Email. A template is available which you can further customize. Use the context help (?Icons) in the Auto Action and on the help page (click on HELP in the top right menu) for further instructions.
If you send Emails with pdf attachment (invoice, booking template) to Alias-Email addresses from channels the cannel might filter the attachment out so it is not delivered to the guest.
13 Accounting Software
Beds24 integrates with Xero, Kashflow and [[[sevDesk]],. If you want to use another system you can use Make to set up an integration or use the data export function (see above) to download data you want to import into your accounting software.
14 Troubleshooting
- If you can no longer edit content, read this help document: Corrupted Content
Pages in category "Invoice"
The following 12 pages are in this category, out of 12 total. download this selection of articles as a PDF book
