Draftworx Wiki

Appearance

Cashbook (Cloud) ​

What it is: A module within Draftworx Cloud that lets you import or manually enter bank transactions and allocate them to trial balance accounts, creating a detailed monthly transactions layer in the Working Trial Balance.

What it's for ​

The Cashbook is particularly useful for engagements where the client does not use a third-party accounting application, or where you want to reconcile bank transactions at a granular level alongside the trial balance. Once transactions are allocated, they populate the Transactions column on the Working Trial Balance, allowing the monthly Period views (Show Monthly Transactions) to reflect actual movement by month. This enhances cashflow automation and management accounts detail.

How to do it ​

Setting up a bank account ​

  1. Navigate to Financial Data > Cashbook Entries.
  2. Click Select Bank Account and choose the trial balance account that represents the bank account. Optionally, also select a VAT account if VAT tracking is needed.
  3. Click OK.

Importing transactions from an OFX file (bank export) ​

  1. With the bank account selected, click Bank OFX.
  2. Browse to the downloaded OFX file from your bank and click OK.
  3. All imported transactions arrive as Unallocated and do not affect the bank balance until allocated.
  4. For each transaction, use the Account dropdown to select the trial balance account it should be allocated to. Multiple rows can be selected together and batch-assigned.
  5. For transactions subject to VAT, tick the VAT checkbox. The system calculates the VAT-exclusive amount and the VAT portion separately.
  6. Click Save to post the allocations. The bank balance updates and the Working Trial Balance Transactions column is populated.

Manually entering transactions ​

  1. Select or add a bank account.
  2. Choose the transaction date from the calendar dropdown (this determines which month the transaction falls in on the Working Trial Balance).
  3. Use the Account dropdown (or blue Link Icon) to choose the trial balance account.
  4. Enter the Description and Total, tick VAT if applicable, then press Enter to add the next line.
  5. Click Save when done.

Importing transactions from an Excel template ​

  1. With the bank account selected, click Excel and then Select File.
  2. Map each column in your spreadsheet to the required cashbook fields (Date, Account, Description, Total — similar to importing a trial balance).
  3. Click Import. All transactions appear in the cashbook and can be edited before saving.

Editing the bank account setup ​

If you need to change the linked bank account or add a VAT account after initial setup, click Edit on the cashbook screen, update the dropdown selections, and click OK.

Source ​

https://draftworx.helpjuice.com/en_US/cloud/draftworx-cloud-cashbook

Walkthrough ​