Difference Between Invoice-based and Journal-based Sync

Modified on Thu, 4 Sep at 10:31 AM

When connecting RoomRaccoon to your accounting software, there are two common ways the financial information is synced:

  1. Invoice-based Sync (creating invoices and linking payments).

  2. Journal-based Sync (creating a transaction list by account codes).

RoomRaccoon supports both with the following accounting software:

  • Xero

  • Twinfield

  • Exact

RoomRaccoon supports only Journal-based Sync with the following accounting software:

  • Snelstart

  • E-boekhouden

  • Unit4

  • DATEV

  • ADFinity Accounting

  • Quickbooks

This article explains the difference between the two methods with a simple example.


1. Creating Invoices and Linking Payments

With this method, RoomRaccoon sends guest invoices directly into your accounting software. When a payment is collected, it is also posted and linked to the invoice (NOTE: no payment will be sent without being linked to an invoice in RoomRaccoon). Example:

  • Room charge: €200

  • City tax: €20

  • Guest pays €220 by credit card

  • OTA charges €20 commission

Accounting entries

Invoice created

  • Debit: Accounts Receivable (Guest) → €220

  • Credit: Room Revenue → €200

  • Credit: City Tax Payable → €20

Payment recorded

  • Debit: Bank (or Credit Card Clearing) → €220

  • Credit: Accounts Receivable → €220

Commission expense

  • Debit: OTA Commission Expense → €20

  • Credit: Bank (or Credit Card Clearing) → €20

This approach gives you full guest-level visibility in accounting (who owes what, which invoices are paid).


2. Creating a Transaction List by Account Codes

With this method, RoomRaccoon sends summarized journal entries instead of individual invoices. These journals are usually grouped by day. Example:

  • Room charge: €200

  • City tax: €20

  • OTA payout: €200 net (after €20 commission)

Journal entry

  • Debit: Bank → €200

  • Debit: OTA Commission Expense → €20

  • Credit: Room Revenue → €200

  • Credit: City Tax Payable → €20

This approach gives you a clean financial breakdown without guest details. RoomRaccoon remains the system of record for invoices and payments (i.e. debtor management).


Which Method Should I Use?

Feature

Invoices & Payments

Transaction List (Journals)

Level of detail

Guest-level (invoices, payments)

Summarized totals

Best for

Debtor tracking, customer history, audit trail

Clean reporting, reconciliations, fewer entries

Commission handling

Separate adjustment per invoice

Direct line in journal

Reconciliation

More complex (many invoices vs. few payouts)

Easier (totals match bank/OTA payouts)


Summary

  • Invoices & Payments: Use if you want guest balances and invoices in your accounting system.

  • Transaction List (Journals): Use if you want clean summaries and leave guest-level detail in the PMS.

Both methods are valid — the right choice depends on your accountant’s workflow and reporting needs.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article