Banking Integration

Bring your bank statements into Shipthis and match them to your ledger. Import the statement file your bank gives you, or connect a supported bank in the United States or Canada and pull its settled transactions on request.

The bank transactions of one account in Shipthis: customer and vendor payments listed with their dates, deposit and withdrawal amounts, running balance and references, under the Resync, Auto reconcile and Import Statement buttons

Banking Integrated with Your Freight Forwarding Software

Book a Demo

Bank lines reach Shipthis in one of two ways: a statement file you import, or a connection to a supported bank in the United States or Canada. Either way they arrive as statement entries, ready to be matched to the payments, expenses and journals already in your books.

How a bank statement is reconciled in Shipthis, in four steps: the statement is imported or synced, auto reconcile is run, the remaining lines are matched by hand, and the period is reconciled. Statement lines come from a file import or a bank connection in the United States or Canada, are matched on amount, date and direction, and the period is proved against the statement's closing balance.

Your team runs auto reconcile to match the lines it can place, matches the rest by hand, and then reconciles the period against the statement's closing balance.

Each bank account in Shipthis is linked to its own account in your chart of accounts.

Hassle-Free Statement Import

Upload a bank statement as a CSV, Excel or PDF file. Shipthis reads it and suggests which column is which, and nothing is imported until you have confirmed.

  • Check the extracted totals against the totals the statement itself declares before you import.
  • Rows that fail are listed with the reason, so you can fix them at source.
  • An import can be undone straight afterwards, as long as none of its lines has been matched.
Statement import takes CSV, Excel and PDF files, one file at a time.
A bank statement file, Statement October.pdf, being imported into Shipthis: its Date, Narrative and Ref columns are mapped to Date, Description and Reference for a person to confirm, above a statement summary showing 42 transactions whose totals agree with the statement.
A bank account in Shipthis, Operating account in US dollars, shown as linked to a bank in the United States, with a Resync button; below it the result of a sync started by Claire Martin: 18 settled transactions imported up to 9 November, with pending transactions left for a later sync.

Connect a Supported Bank in the United States or Canada

Where your bank is supported, link the account once and pull its transactions into Shipthis on request, instead of importing a file each time.

  • A person runs Resync: settled transactions up to the previous day come in, and pending ones wait for a later sync.
  • Transactions an earlier sync already brought in are skipped.
  • For every other bank, statement import gives you the same statement entries to match.
Bank connections work today for banks in the United States and Canada only.

Match Statement Lines to Your Ledger

Run auto reconcile, and Shipthis matches statement lines to the ledger entries behind them by amount, date and direction. What it cannot place stays with your team.

  • You choose how far either side of the statement date a match may fall, from the exact day to a few days.
  • Lines left over can be matched by hand, one at a time or several together.
  • Where the ledger has no entry yet, such as a bank fee, the missing document can be created and matched in one step.
Auto reconcile runs when a person starts it.
Four bank statement lines after auto reconcile in Shipthis: three are matched to a customer payment, a vendor payment and a journal entry, and one, a bank fee, is left to match by hand; beside them a note that the run used a window of one day either side of the statement date.
An Accounts role in Shipthis with permission to view, create and change bank records but not to delete them, beside a user, Claire Martin, with two-factor authentication switched on, and a customer payment marked as locked because it is cleared in a reconciliation.

Secure and Safe Banking

Access to banking follows the same controls as the rest of Shipthis: each person signs in to their own account, and roles decide who can reach bank accounts and reconciliations.

  • Each user can switch on two-factor authentication with an authenticator app, and keep backup codes.
  • Single sign-on can be offered where your organisation switches it on.
  • Once an entry is cleared in a reconciliation, the document behind it cannot be deleted, and its date, bank account and amounts cannot be changed, until it is released.
Roles decide who can view, create, change or delete banking records.

Bring a statement in the format your bank gives you, and we will show it imported and matched.

Explore More Accounting Capabilities

Banking sits inside Shipthis accounting, beside the invoices, bills and payments it reconciles.

Statement import, bank sync, matching and reconciliation, step by step.

GAAP-compliant double-entry accounting for forwarders, with multi-currency, accruals and locked periods.

Invoice, cost and settle in more than one currency, with gains or losses recorded at settlement.

Revenue, cost and margin on every job.

One charge master for every charge line, with the sell and buy sides together.

Choose the date that revenue and cost are recognised on.

When two offices share a move, one can open a linked job for the other.

Roles decide who can view, create, change or delete each kind of record.

More Questions?
or Let’s just connect!

Banking Integration Questions, Answered

Which banks can Shipthis connect to?

Statement import works with the CSV, Excel or PDF statement your bank gives you. A direct connection, which pulls settled transactions on request, is available for supported banks in the United States and Canada.

Is banking in Shipthis secure?

Banking follows the same controls as the rest of Shipthis. Each person signs in to their own account, roles decide who can view, create, change or delete banking records, and each user can switch on two-factor authentication. Once an entry is cleared in a reconciliation, the document behind it is locked until it is released.

Is two-factor authentication available?

With Two-Factor Authentication (2FA) and other added security controls, Shipthis ensures you and your team can access your finance network through a single secure and controlled environment.

How does Banking Integration improve efficiency?

Auto reconcile matches statement lines to the ledger entries behind them by amount, date and direction, so your team matches by hand only what it cannot place, and can create a missing entry, such as a bank fee, in the same step.