Transactions¶

Transactions represent every payment flowing in or out of your business. Whether a customer pays for a sale, you pay a supplier, or a bank transfer comes in, each movement is recorded as a transaction in Gem Logic. Transactions can be created manually, generated automatically from orders and purchases, or imported from your bank.

Creating a transaction¶

You can create transactions in several ways:

From the transactions list: click Create transaction and fill in the amount, payment method, date, contact, bank account, category, and any details.
From an order: add a payment directly on the order detail page. Gem Logic tracks the outstanding amount and marks the order as paid once the balance reaches zero.
From a customer purchase: record the payout to a customer selling you goods.
From a stock in: record the payment to a supplier for received stock.
From a customer consignment: record the payout for consignment sales.
From an incoming invoice: create a transaction linked to a vendor bill.
Bank import: upload a CSV file from your bank to bulk-import transactions.
Bank sync: connect your bank via Ponto (Ibanity) or Revolut to automatically retrieve transactions.

Payment methods¶

Gem Logic comes with built-in payment methods: Cash, Credit card, Bank card, Bank transfer, Giftcard, Cheque, Payment terminal, and Stripe.

When paying with a giftcard, Gem Logic validates the code, checks that the card is active and has sufficient balance, and automatically deducts the amount.

When paying with cash, the system calculates the change to return and requires a cash register to be selected.

Detail page¶

The transaction detail page shows:

Transaction details: amount (color-coded green for incoming, red for outgoing), payment method, date, bank account, contact, linked order or purchase, cash register, structured communication, external IDs, tags, and free-text details.
Invoice reconciliation: link the transaction to incoming or outgoing invoices. Gem Logic suggests matches based on amount and date. You can also search and browse unlinked invoices manually. Transactions are automatically matched to invoices when a structured communication or invoice reference is found in the transaction details.
Documents: attach files to the transaction.

Cash registers¶

Cash registers track the physical cash in each of your point-of-sale locations. Each register is linked to a marketplace (store location).

From the cash register detail page you can see:

The current cash balance, calculated from the last end-of-day closing plus all cash transactions since.
A list of cash transactions since the last closing.
The full end-of-day closing history.

End-of-day closing¶

At the end of each business day, create a closing to record the evening cash amount and any transfers made. The closing form shows a recap of all transactions grouped by payment method, along with individual transaction details.

A printable end-of-day PDF report can be generated in portrait or landscape format, containing the cash summary and all transactions for that day.

Bank accounts¶

Bank accounts store your IBAN, BIC, holder name, and currency. They can be connected to external services like Ponto or Revolut for automatic transaction syncing.

Filtering¶

The transaction list can be filtered by:

Date range
Amount range
Contact
Currency
Bank account
Payment method
Category
Tags
Connection status (linked/unlinked to invoice, positive/negative)
Flagged

Quick date buttons are available below the search bar for common ranges like today, yesterday, last 7 days, and last 30 days. Transactions can also be exported as a CSV file.