• Export Cashmanager transactions for CCH iFirm

    Before you start, check the following in your client's Cashmanager RURAL database:

    • Bank Accounts are balanced
      Make sure all transactions are reconciled to the bank account(s).
      All transactions will be exported regardless of whether they're reconciled or not.

    • Codes are aligned
      Check that your client's Cashmanager RURAL code list has been mapped to your chart of accounts.
      Any transactions that haven't got a corresponding accountants code will be allocated to a SUSPENSE code in the .csv file.

    • Amounts
      Make sure there are no transaction with $0.00 in the amount. They will not import into the general ledger.

    Step 1 - Export transactions out of Cashmanager

    From the Transactions screen:

    1. Click on the Export menu.

    2. Select Accountants.

    3. Set the Accountants format to Xero.

    4. Select the financial year you want to export.

    5. Select the folder destination and click OK.

    0_1509508375546_upload-c9535715-2d41-4ef7-9fd9-cace17225e3b

    Step 2 - Customise the Cashmanager .csv file

    After you've opened the .csv file in Excel, enter the following column headers:

    0_1509509080224_upload-04813bba-379c-4973-b226-1a8ebf3090e9

    Column Header
    A Date
    B Amount
    C Comment
    D CodeDescription
    E Reference
    F Code
    G TaxType
    H Tax (create New olumn)
    I TransactionQuantity

    Amount
    Cashmanager displays expense amounts as negative and income as positive.
    Because CCH requires the opposite in the export file, you need to change the way the amounts are displayed.

    1. Put -1 into a cell to the side of the transaction information.

    2. Copy the cell.

    3. Highlight all figures in the amount column.

    4. Right-click your mouse and select Paste Special.

    5. Tick multiply.

    6. Click OK.

    0_1509573860871_upload-985e2f5b-21b4-4d1b-b7ee-de685ffa4794

    TransactionQuantity
    The same applies for TransactionQuantity as for the amount so if a quantity relates to an amount, it needs to be adjusted.

    Repeat steps 1-6 above so that the quantities are correctly displayed with their corresponding amount.

    Tax
    GST is not included in the .csv file during the initial export. It needs to be calculated and added into to Tax (column H).

    1. Sort the spreadsheet by TaxType.

    2. Enter the following formula into the Tax column against the first transaction line: =SUM(B2*3/23)

    3. Drag the figure in the first line down the column to calculate GST for the remaining income and expense lines.

    0_1509582922408_upload-63ae476f-8e58-4502-a083-c2549c30ff61

    Payables and Receivables

    1. Sort the spreadsheet by Date.

    2. For transaction lines that have a date after balance date, change their date to reflect the last day of the income year.


  • Comments

Log in to reply

Looks like your connection to CRS Community was lost, please wait while we try to reconnect.