Vai al contenuto principale

Account Mapping Explained

This article explains every account available in Tebi's account mapping configuration. For each account, you'll find a plain-language description and an example of the journal entry it generates.

To configure your account mapping, go to the Back Office > Accounting > Bookkeeping Export Mapping.

Sales

Tax Payable

Tax payable is money your company owes to the tax authorities. This includes VAT, environmental taxes, and wage taxes or social insurance.

Journal entry (when a sale including tax is recorded):

Debit

Credit

Cash / Card / Accounts Receivable

Sales (net amount)

Tax Payable (tax amount)

Tips Payable

Tips payable represents the sum of money given by a customer on top of the cost of a service. These amounts are usually redistributed to employees.

Journal entry (when a tip is received):

Debit

Credit

Cash / Card

Tips Payable

Journal entry (when tips are paid out to staff):

Debit

Credit

Tips Payable

Cash / Bank

Sales Revenue

Sales revenue is a balance sheet account used to track the total gross revenue before it is allocated elsewhere. This account is marked as n/a – not in P&L, meaning it does not appear on the Profit & Loss statement directly.

Journal entry:

Debit

Credit

Cash / Accounts Receivable

Sales Revenue


Sales

Gross sales represent the total revenue of your company before any deductions for discounts, allowances, or returns. It reflects the total value of all products and services sold.

Journal entry:

Debit

Credit

Cash / Card / Accounts Receivable

Sales


Card Payments

Card

This account holds amounts paid by customers on a payment terminal that have not yet been confirmed by your payment service provider (PSP). Once confirmed, the balance moves to Card Receivable.

Journal entry (when customer pays by card terminal):

Debit

Credit

Card

Sales / Tax Payable

Journal entry (when PSP confirms the payment):

Debit

Credit

Card Receivable

Card


Card Receivable

Card receivable represents amounts paid on a payment terminal by customers, confirmed by the PSP, but not yet received in your bank account.

Journal entry (when PSP confirms and funds are in transit):

Debit

Credit

Card Receivable

Card

Journal entry (when funds are received in bank):

Debit

Credit

Bank

Card Receivable


Cash Payments

Cash

Cash refers to money held in physical form (bank notes and coins), stored in a cash drawer or a safe.

Journal entry (when a cash sale is made):

Debit

Credit

Cash

Sales / Tax Payable


Cash Difference

Cash differences arise when the physical cash present in the company does not match the amount recorded in Tebi. This can be caused by mistakes or theft.

Journal entry (cash shortage):

Debit

Credit

Cash Difference (expense)

Cash

Journal entry (cash surplus):

Debit

Credit

Cash

Cash Difference (income)


Pre-Payment via POS

Pre Paid

Prepayments represent payments made to Tebi outside the POS (e.g. via bank transfer), but recorded in the POS using the "Prepayment" payment method in the Tebi app.

Journal entry (when prepayment is recorded in POS):

Debit

Credit

Pre Paid

Sales / Accounts Receivable


Online Payments

Ecom Payment Receivable

QR / ecom payment receivable refers to amounts paid by customers via QR code, confirmed by the PSP, but not yet received from the PSP.

Journal entry (when PSP confirms QR payment):

Debit

Credit

Ecom Payment Receivable

Ecom Payment

Journal entry (when funds are received):

Debit

Credit

Bank

Ecom Payment Receivable


Other Income

Other income is income from activities unrelated to your core business, such as interest received, sub-lease income, gains on asset sales, or foreign exchange gains.

Journal entry:

Debit

Credit

Cash / Bank

Other Income


Invoicing

External Payment Receivable

This account is used for payments handled by a third-party company that has no PSP integration and no syncing with Tebi Accounts.

Journal entry:

Debit

Credit

External Payment Receivable

Sales / Tax Payable


Accounts Receivable Pending

This is a technical clearing account for pending transactions. It should not carry a balance under normal circumstances and should not be visible in standard reporting.

Journal entry (temporary, clears automatically):

Debit

Credit

Accounts Receivable Pending

Sales


Gift Cards

Giftcard Pending

This is a crosspost account for gift card transactions. When a customer pays with a gift card, this account is converted into an Accounts Receivable entry.

Journal entry (when gift card is sold):

Debit

Credit

Cash / Card

Giftcard Pending

Journal entry (when gift card is redeemed):

Debit

Credit

Giftcard Pending

Accounts Receivable


Tax Rate Mapping

These accounts map your VAT rates to the correct ledger accounts in your accounting software.

VAT Exempt

Used for transactions that are exempt from VAT. No VAT is charged or posted.

VAT Low

Used for transactions subject to the reduced VAT rate (e.g. food and beverages in many countries).

Journal entry:

Debit

Credit

Cash / Card

Sales (net)

Tax Payable – VAT Low

VAT High

Used for transactions subject to the standard (high) VAT rate.

Journal entry:

Debit

Credit

Cash / Card

Sales (net)

Tax Payable – VAT High

VAT Zero

Used for transactions that are zero-rated for VAT. VAT is charged at 0%, but the transaction is still VAT-reportable.


Revenue

Sales

Gross sales before any deductions. See the Sales section above for a full explanation.

Payment Surcharge Net

The net amount of any surcharge added to a payment (e.g. a card surcharge passed on to the customer), excluding tax.

Journal entry:

Debit

Credit

Cash / Card

Payment Surcharge Net


Contra Revenue

Contra revenue accounts reduce gross revenue to arrive at net revenue on the P&L.

Sales Returns

A sales return occurs when a customer returns a product. Causes include damages, order picking mistakes, or shipping delays.

Journal entry:

Debit

Credit

Sales Returns

Cash / Accounts Receivable


Sales Allowances

A sales allowance is a price reduction given to a customer who accepts a product or service that did not meet expectations (e.g. quality issues, incorrect pricing).

Journal entry:

Debit

Credit

Sales Allowances

Cash / Accounts Receivable


Sales Payment Discounts

A sales payment discount (also called an early payment discount, cash discount, or settlement discount) is offered to customers who pay their invoice within a specific time frame.

Journal entry:

Debit

Credit

Sales Payment Discounts

Accounts Receivable


COGS (Cost of Goods Sold)

Purchase

Cost of goods sold (COGS) represents the direct costs of producing or acquiring the products or services you sell. It is deducted from revenue to calculate gross profit.

Journal entry (when goods are purchased):

Debit

Credit

Purchase / COGS

Accounts Payable / Cash


Freight In

Freight-in is the transportation cost for receiving goods or materials from a supplier. These costs are part of the total cost of purchasing inventory.

Journal entry:

Debit

Credit

Freight In

Cash / Accounts Payable


Contra COGS

Purchase Returns

Purchase returns occur when you send goods back to a supplier, due to damages, order mistakes, or shipping delays.

Journal entry:

Debit

Credit

Accounts Payable / Cash

Purchase Returns


Purchase Allowances

A purchase allowance is a reduction in the agreed purchase price offered by a supplier (e.g. for ordering a minimum quantity, or for retaining damaged goods).

Journal entry:

Debit

Credit

Accounts Payable / Cash

Purchase Allowances


Purchase Payment Discounts

Purchase payment discounts are discounts offered by suppliers when you pay an invoice within a certain time frame. Also called early payment discounts or settlement discounts.

Journal entry:

Debit

Credit

Accounts Payable

Purchase Payment Discounts

Cash (net payment)


Opex Other (Operating Expenses - Other)

Office Supplies

Costs for items needed to run the office, such as paper, notebooks, pens, and toner cartridges.

Journal entry:

Debit

Credit

Office Supplies Expense

Cash / Accounts Payable


IT

IT costs include fees for cloud and hosting services, online subscriptions, and software (e.g. POS, e-commerce, and app subscriptions).

Journal entry:

Debit

Credit

IT Expense

Cash / Accounts Payable


Bad Debt

Bad debt represents amounts that cannot be collected or reconciled. This includes unpaid customer invoices, payment discrepancies, and other irrecoverable differences.

Journal entry:

Debit

Credit

Bad Debt Expense

Accounts Receivable


Bank Costs

Any expenses charged by your bank, including fees for credit or debit cards and international transaction fees.

Journal entry:

Debit

Credit

Bank Costs

Bank / Cash


Insurance

The cost of acquiring insurance coverage over a period of time, including liability and property insurance.

Journal entry:

Debit

Credit

Insurance Expense

Cash / Prepaid Insurance


Legal

Everyday legal fees associated with the operating activities of your company. One-time costs and legal settlements should be recorded as non-operating expenses instead.

Journal entry:

Debit

Credit

Legal Expense

Cash / Accounts Payable


Other Expense

A residual bucket for expenses that do not fit into any other expense category. These are not related to your primary business activities and may include write-offs for bad debt.

Journal entry:

Debit

Credit

Other Expense

Cash / Accounts Payable


Opex Employees

Payroll Salaries

All costs to compensate employees for their work, including gross wages and payroll taxes.

Journal entry:

Debit

Credit

Payroll Salaries

Cash / Bank

Tax Payable (payroll taxes)


Other Payroll

Payroll expenses beyond wages, such as bonuses, paid leave, insurance, pensions, and other company benefits.

Journal entry:

Debit

Credit

Other Payroll

Cash / Bank / Liability


Staff Expenses

Reimbursable costs incurred by employees on behalf of the business, such as travel, meals, laptops, phones, and internet — paid outside of payroll.

Journal entry:

Debit

Credit

Staff Expenses

Cash / Accounts Payable


Opex Sales and Marketing

Sales and Marketing

Costs incurred to advertise your products or services, including online advertising, agency fees, and promotional gifts.

Journal entry:

Debit

Credit

Sales & Marketing Expense

Cash / Accounts Payable


Payment Costs

Transactional fees charged for processing payments (e.g. PSP fees).

Journal entry:

Debit

Credit

Payment Costs

Cash / Bank


Lease

Regular (often monthly) fees paid for the right to use a property, asset, or piece of equipment.

Journal entry:

Debit

Credit

Lease Expense

Cash / Accounts Payable


Opex Depreciation & Amortization

Depreciation

The gradual reduction in the book value of a tangible fixed asset (e.g. computers, furniture, machinery) over its useful life. Depreciation is a non-cash expense.

Journal entry (monthly):

Debit

Credit

Depreciation Expense

Accumulated Depreciation


Amortization

The incremental expensing of an intangible fixed asset (e.g. intellectual property, goodwill) over its period of use. Amortization is a non-cash expense.

Journal entry (monthly):

Debit

Credit

Amortization Expense

Accumulated Amortization


Opex Building

Rent

The cost of renting your business premises from a landlord over a period of time.

Journal entry:

Debit

Credit

Rent Expense

Cash / Accounts Payable


Maintenance

Costs to repair or maintain the condition of an asset. When costs extend the useful life or increase the productive capacity of an asset, they may be capitalised instead.

Journal entry:

Debit

Credit

Maintenance Expense

Cash / Accounts Payable


Utilities

Costs for using public infrastructure services: electricity, gas, water, sewage, waste disposal, and telephone services.

Journal entry:

Debit

Credit

Utilities Expense

Cash / Accounts Payable


Other Income

Other Income

Income from activities unrelated to the main focus of your business, such as interest received, rent from sub-leasing, gains on asset sales, and foreign exchange gains.

Journal entry:

Debit

Credit

Cash / Bank

Other Income

Hai ricevuto la risposta alla tua domanda?