For the complete documentation index, see llms.txt. This page is also available as Markdown.

Add Multiple Checks and Deposits

Type or paste up to 50 checks and deposits into a spreadsheet and record them in one import, then fix any rows that fail.

The importer records up to 50 checks and deposits at a time from a spreadsheet you type or paste into. Each row becomes one check or deposit with a single line.

Recording checks and deposits is available for clients on Basic, Plus, or Advanced.


Open the importer

  1. Click New at the top of the sidebar, or press CMD+K (Ctrl+K on Windows), and select Add check or deposit.

  2. In the Add check form, click Add multiple.

The Import checks and deposits drawer opens. If you picked a bank account in the form, the first row starts with it. If you had already entered details in the form, Kick asks Discard this check? first. Click Discard and import to continue, or Keep editing to go back.


Fill in the rows

Type into the rows or paste from a spreadsheet. Columns marked with an asterisk are required.

  • Reference number. Optional, up to 64 characters.

  • Date. The date the check was written or the deposit was made.

  • Bank account. A row with a negative amount can only use a checking account.

  • Counterparty.

  • Memo. Optional, up to 1,000 characters.

  • Category. Shown and required unless the workspace codes transactions to GL accounts directly.

  • Cash ledger. Required.

  • Accrual ledger. Optional.

  • Class. Shown for clients on Plus or Advanced.

  • Amount. Negative for a check, positive for a deposit, at most two decimal places.

  • Type. Filled in from the amount: Check or Deposit. You can't edit it.

The header shows how many checks and deposits the sheet holds, for example "2 checks • 1 deposit", and the totals row adds up Amount. Blank rows are ignored.

Import checks and deposits drawer with required columns marked by an asterisk and Type filled in as Check for the negative amounts

Each row records one line. To split a check across several accounts, record it on its own from the Add check form.


Import

Click Import checks and deposits.

Kick checks every row before recording anything. If a row has a problem, nothing is imported: the cells that need attention are outlined in red and a message names the first one, for example "Row 4: Choose a counterparty". Fix them and import again.

Import sheet with the empty Counterparty cell on row 4 outlined in red, and Type showing Deposit for the positive amount on row 3

Rows that pass are recorded the same way as a single check or deposit, posting to the books on their date.

When some rows fail

A row can still fail when it's recorded, for example when its date is in a locked or reconciled period. The other rows are recorded anyway.

Result
What you see

Every row recorded

"Imported" with the count, for example "Imported 4 items". The drawer closes.

Some rows recorded

"Imported" with the count and how many failed, plus the first failure's row and reason. Recorded rows leave the sheet, and failed rows stay highlighted.

No rows recorded

"Failed to import" with the count, plus the first failure's row and reason.

Fix the remaining rows and click Import checks and deposits again.


Limits

  • Up to 50 checks and deposits per import.

  • One line per row.

Last updated

Was this helpful?