Difference between revisions of "Category:Invoice"

From Beds24 Wiki
Jump to navigation Jump to search
 
(50 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->INVOICE
+
<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.  
 
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.
 
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
+
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===
Line 16: Line 20:
  
 
===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 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 SETTINGS->ACCOUNT->PREFERENCES.
+
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 22: Line 35:
  
 
===Invoice Status===
 
===Invoice Status===
The "Status" field in the "Charges and Payments" tab can be used to specify the type of item. Status can be preset for upsell items and for extra invoice charges.  
+
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. /  
 
[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. /  
Line 43: Line 56:
  
 
===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->PROPERTIES->UPSELL ITEMS).  
+
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
Line 52: Line 65:
 
<embedvideo service="youtube">https://www.youtube.com/watch?v=wZr1_j7PJ0I</embedvideo>
 
<embedvideo service="youtube">https://www.youtube.com/watch?v=wZr1_j7PJ0I</embedvideo>
  
==Lock invoices==
+
<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.
 
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.
+
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==
 
==Different Invoice Address==
1. Go to SETTINGS->PROPERTIES->BOOKINGQUESTIONS 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".  
+
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.
 
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->PRINT TEMPLATES).
+
If you need a separate invoice template you can use one of the print templates ({{#fas:cog}} (SETTINGS) GUEST MANAGEMENT->INVOICING).
  
 
== Currencies ==
 
== Currencies ==
Line 72: Line 103:
  
  
You can use the "Status" field in the "Charges and Payments" tab of the booking if you need to display a second currency. Use [INVOICETABLE2] to show both currencies.
+
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 ==
Line 87: Line 120:
 
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.
 
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].
  
== Reports ==
 
 
Monthly Invoice Revenue can be generated in the menu REPORTS->STANDARD REPORTS.  
 
Monthly Invoice Revenue can be generated in the menu REPORTS->STANDARD REPORTS.  
  
In REPORTS->CUSTOM REPORTS you can create custom reports which can include invoice number and invoice date, upsell items, tax, VAT, invoice charges and many more.
+
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.
  
== Invoicees - separate invoices ==
+
== Separate invoices for agents, business travellers, certain OTAs ==
See [[Invoicees|this help page]] if you are working with agencies, business travelers or repeat guests for whom you need a second invoice.
+
See [[Invoicees|this help page]] for more information.
  
 
== Send Invoice via Email ==
 
== 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.
+
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.
 
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 ==
 
== Accounting Software ==
Beds24 integrats with [[Kashflow.com|Kashflow]]. If you want to use another system you can use the data export function (see above) to download data you want to import into your 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

Invoicing
This page is about the menu SETTINGS->GUEST MANAGEMENT->INVOICING 

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