The transactions are exported as a manual journal in draft status. For each booking, one journal is created. The amounts are gross amounts incl. tax.
Example 1: Reservation for one night. Cost: 38 GBP. Pay with cash.
apaleo’s bookings:
|
The bookings on 10.08.2020 were booked by night run. The third booking was booked by check out.
These three bookings were imported in Quickbooks in two journals:
1) for 10.08.2020:
2) for 11.08.2020:
There are the following accounts mappings in the AFinConnector application:
apaleo account | Xero account |
Revenue Accommodation (20%) | Revenue Accommodation |
Receivables | Revenue received in Advance |
Cash Payment (1600) | Cash Account |
The amounts are converted as gross amounts. The description field contains the reference of the booking and PSP Reference or comment from receipt field.
Example 2: Accommodation for two nights with breakfast. Pay with credit card.
Total costs 100 GBP. 80 GBP accommodation and 20 GBP breakfast. 50 GBP payed in advanced with Master Card. The rest, 50 GBP, payed by check out with American Express Card.
apaleo’s bookings:
Business date | Debited account number | Credited account number | Amount | Currency |
16.08.2020 | 1101 | ZOILRKRG-2_Receivables | 50 | GBP |
15.08.2020 | ZOILRKRG-2_Receivables | RevenueAccommodation_Normal | 33,33333333 | GBP |
15.08.2020 | ZOILRKRG-2_Receivables | VatNormal | 6,666666667 | GBP |
15.08.2020 | ZOILRKRG-2_Receivables | VatNormal | 1,666666667 | GBP |
15.08.2020 | ZOILRKRG-2_Receivables | RevenueFoodAndBeverages_Normal | 8,333333333 | GBP |
14.08.2020 | LiabilitiesVatNormal | ZOILRKRG-2_Receivables | 6,666666667 | GBP |
14.08.2020 | ZOILRKRG-2_Liabilities | ZOILRKRG-2_Receivables | 33,33333333 | GBP |
14.08.2020 | ZOILRKRG-2_Receivables | VatNormal | 6,666666667 | GBP |
14.08.2020 | ZOILRKRG-2_Receivables | RevenueAccommodation_Normal | 33,33333333 | GBP |
14.08.2020 | ZOILRKRG-2_Liabilities | ZOILRKRG-2_Receivables | 8,333333333 | GBP |
14.08.2020 | LiabilitiesVatNormal | ZOILRKRG-2_Receivables | 1,666666667 | GBP |
14.08.2020 | ZOILRKRG-2_Receivables | RevenueFoodAndBeverages_Normal | 8,333333333 | GBP |
14.08.2020 | ZOILRKRG-2_Receivables | VatNormal | 1,666666667 | GBP |
10.08.2020 | 1104 | ZOILRKRG-2_Liabilities | 41,66666667 | GBP |
10.08.2020 | 1104 | LiabilitiesVatNormal | 8,333333333 | GBP |
On 10.08.2020 there are bookings for the paying of 50 GBP in advanced. All bookings on 14.08.2020 and 15.08.2020 were done by night run. There are separated bookings for accommodation and breakfast. On 14.08.2020 the liabilities accounts were balanced with the revenue accounts. The last booking is the paying of the remaining amount of 50 GBP with a credit card.
Following bookings were imported in Quickbooks in four journals:
1) for 10.08.2020:
2) for 14.08.2020:
3) for 15.08.2020:
4) for 16.08.2020:
There are the following accounts mappings in the AFinConnector application:
Apaleo account | Xero account |
Revenue Accommodation (20%) | Revenue Accommodation |
Revenue Food (20%) | Revenue Food |
Receivables | Revenue received in Advance |
American Credit Card Payment (1101) | Master Card |
Master Card Credit Payment (1104) | Master Card |
Liabilities (20%) | Liability Account 20% |
The amounts are converted as gross amounts.