• Create a split or multi-line transaction

    Separating and recording each item within the same invoice/statement means you will have a more detailed picture of your expenses and income, which can be useful for making financial decisions or when analysing the performance of your business.

    Using the sample milk production supplier statement below as an example, there are four key pieces of information that you’d need to consider when recording the milk transaction. Although it could be entered as a single-line transaction, reflecting only what happened at the bank, it’s better to create a multi-line transaction so that you can separate out costs and income:

    0_1473292772187_Screen Shot 2016-09-08 at 11.59.11 AM.png

    1. The amount deposited into or paid out of your bank account.
    2. The gross income amount before any deductions such as DNZ levies or FarmSource purchases.
    3. The Kg/MS produced for the period ended.
    4. A breakdown of any deductions i.e. splitting FarmSource purchases between calf rearing, shed expenses and animal health or any other expenses incurred.

    In the examples below we’ve used a milk payment to show the amount banked, what was actually produced and the dollar value associated with it, and deductions.

    TIP: If you want to separate items on a trader statement i.e. Farmlands or FarmSource, check out our topic on how to import it directly into the bank transaction. This way you're ensuring the integrity of the banked amount, while capturing all the purchase/sale details.

    Create a multi-line transaction while importing bank transactions

    In the Load Bank Transactions screen you'll notice the Date and Amount fields for each transaction are greyed out and can't be changed.

    This is because they have come from your bank; they're the best source of truth so why should you need to change them?

    However, you can easily turn them into a multi-line transactions by adjusting the Code Amount and the aligned codes to reflect gross income and deductions.

    If you enter a Code amount smaller or larger than the total Amount, another line will be created for the transaction until the remaining amount balances back to the banked amount.

    0_1500352132414_9c16cf97-8818-4863-b8c6-628612f50b34-image.png

    1. Allocate the category and extended codes correspond to the item you're recording.

    2. Enter the GST inclusive amount that corresponds to the item you’ve coded.

    3. Record any quantities like kg/MS or stock tallies that relate to the item you've coded.

    4. Click OK to create a new line in the transaction, or press Tab until a new line is created.

    Because the Code amount doesn’t equal back to the Amount from the bank, a remaining amount of -$12,000.00 is required to balance the transaction.

    Continue to enter item amounts and codes until the transaction balances back to the banked amount.

    Manually create a multi-line transaction

    Before you start, it’s a good idea to understand how this screen behaves when entering multi-line transactions.

    Bank details - The top half of the screen should always reflect what happened at the bank i.e. the date the transaction occurred, the amount that was deposited or paid out, and the payee.

    Code details - The second half of the screen displays management and coding information i.e. where the costs/income are allocated within the business and the amount associated with each item. This is where you can manipulate the Code amount to reflect gross income and deductions.
    If you enter a Code amount smaller or larger than the total Amount, another line will be created for the transaction until the remaining amount reaches $0.00.

    0_1473292977068_Screen Shot 2016-09-08 at 12.02.33 PM.png

    1. Enter the Transaction date as it appears on your bank statement.

    2. Enter the Amount that appears on the bank statement or total amount you anticipate paying or receiving.

    Optional: Record the payee details (this can be handy if you need to locate the transaction later).

    1. Allocate the category and extended codes that relate to the item you’re recording.

    2. Enter the GST inclusive amount that corresponds to the item you’ve coded.

    3. Enter any quantities i.e. Kg/MS or stock numbers.

    Because the Code amount doesn’t equal back to the Amount above, a remaining amount of $12,000.00 is required to balance the transaction.

    1. Click Ok or press Tab on your keyboard to create a new line within the transaction.

    Continue to enter item amounts and codes until the transaction balances back to $0.00.


  • Comments

Log in to reply

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