Skip to content

Bank Transaction

A Bank Transaction is one line from a bank statement or banking integration. It records the date, amount, description, and Bank reference. You reconcile it with a Payment Entry, Journal Entry, or another supported voucher so Bravo Hub ERP can compare statement activity with the General Ledger.

Create the Bank, Bank Account, and linked Bank ledger. Confirm that the statement belongs to the correct Company account and currency.

Set a consistent import process. Keep the original statement file, define who imports it, and prevent the same period from being loaded twice.

Bring Bank Transactions into Bravo Hub ERP

Section titled “Bring Bank Transactions into Bravo Hub ERP”

Transactions can be synchronized through a supported integration, imported from a statement, loaded with Data Import or API, or entered manually for controlled correction.

The list should show real statement activity rather than an empty example.

Bank Transaction list with deposits and withdrawals

Before importing a full statement:

  1. check the date and amount formats;
  2. confirm whether credits are deposits and debits are withdrawals;
  3. map description, reference, and transaction identifier fields;
  4. test a few rows;
  5. compare the imported total with the source statement.

Use the Bank master’s transaction mapping when the source headings differ from the expected fields.

Open a transaction and verify the Date, Bank Account, currency, and amount direction. A receipt is stored as Deposit. A payment or charge is stored as Withdrawal.

Date, Bank Account, and deposit amount

Review the description, bank reference number, transaction identifier, and transaction type. These fields help find the correct accounting voucher and detect duplicates.

Description, reference number, and transaction type

Do not overwrite the bank’s description merely to make matching easier. Preserve original evidence and use party, allocation, or comments for internal classification.

FieldWhat it controls
DateStatement value or transaction date supplied by the Bank.
Bank AccountCompany Bank Account to which the statement line belongs.
CompanyDerived or selected Company for the transaction.
DepositIncoming amount on the statement.
WithdrawalOutgoing amount on the statement. A line should not normally have both values.
CurrencyStatement currency. It should agree with the Bank Account and import.
DescriptionNarrative supplied by the Bank.
Reference NumberCheck, transfer, batch, or other Bank reference.
Transaction IDStable identifier used for traceability and duplicate control.
Transaction TypeBank-supplied classification such as ACH, wire, fee, or card settlement.
Payment EntriesAccounting vouchers matched or created against the statement line.
Allocated AmountPortion connected to accounting vouchers.
Unallocated AmountBalance that still needs matching or classification.
Party Type and PartyCustomer, Supplier, Employee, or other identified counterparty.
Included FeeFee already included in the statement amount.
Excluded FeeFee reported separately from the main amount.

Use Bank Reconciliation to find candidate vouchers. Compare amount, date, reference, party, and description.

Choose the existing Payment Entry or Journal Entry when the books already contain the transaction. One statement line may be matched with several vouchers when the Bank combines activity, and one voucher may require careful treatment when the Bank splits it.

Create a Payment Entry for a genuine receipt, payment, or transfer that has not been recorded. Create a Journal Entry for an appropriate fee, interest, or adjustment. Verify accounts, party, tax, Cost Center, and references before submission.

Do not create a new voucher until you have searched for an existing one. Duplicate payments are one of the most costly reconciliation mistakes.

StatusMeaning
PendingTransaction is awaiting processing.
UnreconciledIt has not been fully matched to accounting vouchers.
ReconciledThe amount has been matched and accepted in reconciliation.
SettledThe transaction’s configured processing is complete.
CancelledThe Bank Transaction was canceled under Bravo Hub ERP rules.

Fees, differences, and combined settlements

Section titled “Fees, differences, and combined settlements”

When a Customer pays an invoice less a Bank fee, record the gross receipt and fee according to your accounting policy. Do not silently reduce the invoice allocation without recording the difference.

For card or marketplace settlements, one deposit may cover several Sales Invoices after fees and refunds. Use the reconciliation and allocation tools to connect the combined amount to the correct vouchers and record the settlement difference in the correct account.

For foreign currency, verify both statement currency and Company-currency accounting. Record exchange differences through the supported payment workflow rather than editing imported amounts.

Review import mapping. Incoming money belongs in Deposit and outgoing money in Withdrawal. Correct the mapping before importing more rows.

Compare Transaction ID, reference, date, amount, and source file. Keep one valid transaction and remove or cancel the duplicate through your approved process.

Check Bank Account and ledger, amount, date range, currency, party, document status, and whether the payment is already reconciled.

Review fees, deductions, combined payments, split vouchers, and rounding. Allocate only supported amounts and record the remaining difference explicitly.

Confirm the file encoding, heading row, Bank mapping, date format, mandatory columns, and whether the import reported rejected rows.

Does a Bank Transaction replace a Payment Entry?

Section titled “Does a Bank Transaction replace a Payment Entry?”

It does not. The Bank Transaction is statement evidence. The Payment Entry normally posts the accounting movement and invoice allocation.

Correct the source or import error before reconciliation. Preserve the original Bank evidence and avoid changing a valid statement value to force a match.

It can. Match or create the Customer payment and allocate it across the relevant invoices using the supported reconciliation workflow.