• How to import your trader statement into a bank transaction

    The team on the Helpdesk often get asked "what is the best way to import my Farmlands, Farmsource or PGG statement?"

    If you use Bank Feeds, or import transactions from your bank, the easiest and most accurate way is to bring the statement directly into the imported bank transaction.

    By importing your statement directly into the bank transaction, you retain the integrity of the bank transaction.
    It also ensures that you don’t end up with duplicate records that could be included in your GST return.

    Import your trader statement in 5 easy steps

    Make sure you've imported and coded your bank transactions first including the transaction for your trader account.

    If you're not sure what to code it to, try FW (Farm Working). Once you import the trader statement, you'll be able to allocate the correct code to each item.

    STEP 1.
    Locate the bank transaction in Cashmanager RURAL and put it into edit mode. When the bottom of your screen turns blue, the transaction is ready to edit.

    Tip: To identify a bank transaction that has been imported, look for the + symbol in the Page column.

    STEP2
    Click on Import and select the trader you want to import.

    If you have saved a .csv file to your PC, browse for the file and click OK. If you use the Farmlands Feed, you can choose which statement period you want to import.

    0_1497917919732_693b0a0f-2fa7-4647-b984-c30404c224a5-image.png

    STEP 3
    Click Yes to bring the statement items into the bank transaction.

    0_1497917650360_24bea915-b41f-4fe7-be1b-e24ea6484f95-image.png

    The transaction now becomes a split or multi-line transaction while still retaining the transaction date and amount that was paid from your bank account.

    STEP 4
    Every line needs a category and extended code before you can complete the transaction. Try Autocoding to quickly code each item.

    STEP 5
    Once each item has been coded, click Ok to save the transaction.

    0_1497918173128_3dc647fe-f933-4327-8246-95c39a816096-image.png

    TIP: Want to know how to properly record your milk income? Have a look at How to enter a split or multi-line transaction.

    Relevant Topics

    Reconcile transactions
    Farmlands Feeds
    Scan my Bills


  • Comments

Log in to reply

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