<aside> Xero is a cloud-based accounting software for small businesses that provides solutions for for streamlined financial management.
The Xero integration is available for BETA users on Community tier or higher. To use the integration you also need a Xero account.
<aside> ⚠️
ATTENTION:
Your Price Categories in BETA, must be an exact-match to an existing Xero/Quickbooks account.
If no exact match is found, BETA falls back to the BETASL<TAX>
sales account for that item’s tax rate.
</aside>
<aside>
:
(colon) Separator for accountingWhen using the Xero or QuickBooks integration, your Price Categories in BETA must match the account names in your accounting system for the integration to work properly.
Here’s how it works:
:
when sending data to Xero or QuickBooks.
Event:Youth
Event:Kids
Event:Adult
-
instead of a colon:
Event-Youth
is treated as a completely different account called “Event-Youth.”✅ Use a colon
:
to group categories to the same account.❌ Avoid using a dash
-
if you want items to go to the same account.
:
and a -
</aside><aside> <img src="/icons/arrow-northeast_blue.svg" alt="/icons/arrow-northeast_blue.svg" width="40px" /> Please see how to change a Price category in your BETA dashboard here
Edit create/delete a price category/label
</aside>
</aside>
<aside>
Below is an Overview of the entire process, and what you need in place, to keep your BETA transactions flowing into Xero/Quickbooks automatically
</aside>
<aside>
In BETA’s Integrations settings, authorize access to your Xero/Quickbooks organization. Ensure API access is enabled in Xero/Quickbooks and that your BETA and Xero/Quickbooks time-zones match.
</aside>
<aside>
In BETA’s Xero/Quickbooks integration settings, choose how you’d like your transactions bundled each night into the Draft Journal. You can group by:
Aggregated Task | Non-Aggregated Task |
---|---|
For each category and sales tax rate, one line per category (net of sales and refunds) | For each category and sales tax rate, one line for sales (if any), one line for refunds (if any) |
Values listed per top-level category (i.e. both Cafe:Food and Cafe:Drinks sales would go into Cafe category) |
Values listed per category (i.e. separate listings for Cafe:Food and Cafe:Drinks ) |
For each payment type, one line indicating the total net movement (sales minus refunds) | For each payment type, one line for sales (if any) and one line for refunds (if any) |
This setting determines exactly which subtotals appear on each journal line—so you see the right level of detail when you review and post in Xero/Quickbooks.
</aside>
<aside>
On first connect, BETA will generate three default accounts in Xero/Quickbooks:
If you prefer your own accounts, you can rename or map Price Categories to any existing Xero/Quickbooks account code.
</aside>
<aside>
In BETA, list all your Price Categories (e.g. “Day Pass,” “Membership,” “Cafe:Drinks”). For each Category, either:
Exact-match its name to a Xero/Quickbooks account, or
Enter a custom Account Code in BETA to override the default.
• Categories using a colon (e.g. Cafe:Food
) will post subtotal lines under the parent account (Cafe
).
<aside>
Tip: How the :
Naming Works
Parent:Child Syntax
- Anything before the colon (e.g.
Cafe
inCafe:Drinks
) must match a Xero/Quickbooks account name.- Anything after the colon (e.g.
Drinks
) becomes a separate line item sub-total under that parent account.- If no colon is used, BETA simply looks for an exact match to your account name or falls back to
BETASL<TAX>
. </aside>
</aside>
<aside>
At 1 AM daily, BETA gathers all day’s sales, refunds, gift-cards, deposits, payroll, etc., into a single Draft Journal in Xero/Quickbooks. Lines are grouped by Price Category (or fallback BETASL<TAX>), tax rate, and payment type.
</aside>
<aside>
</aside>
<aside>
</aside>
Screen Recording 2024-04-23 at 10.10.33.mov
<aside>
</aside>
<aside>
While you can customise the names of your accounts, please do not alter the Account Code
in Xero.
</aside>
<aside>
</aside>
<aside>
</aside>
When you integrate BETA with Xero the system will automatically create specific accounts in Xero/to help manage your financial transactions. Here's what you need to know.
BETALIAB