Help CenterClockWork

Import bank transactions and reconcile

Bring in your bank statement and match each line to a payment or an account.

Open ClockWork

Steps

  1. Download a CSV statement from your bank with the date, description and amount of each line.
  2. In ClockWork, open Cash & Banking and click Import at the top.
  3. Choose the bank account under Into account, paste the rows into CSV data, and click Import.
  4. Click the Reconcile tab. Click Match on a line.
  5. If it pays an invoice or bill already in ClockWork, choose that payment and click Match & settle. Otherwise choose an Account and click Post. Use Mark matched, nothing to post for lines that need no entry.

Good to know

  • For lines that repeat, like bank fees, click Create rule so ClockWork suggests the same account next time.

Related articles

Record a payment against an invoice or bill Mark an invoice as paid, or a bill as settled, in full or in part. ClockWork

Still stuck?

Tell us which step stopped you and what you saw on screen. We answer from Support.