Record keeping on VT Cashbook

Newchodge

Moderator
  • Business Listing
    Nov 8, 2012
    22,637
    8
    7,949
    Newcastle
    I use VT Cash book for my personal finance records and I always struggle with the right way to record income.

    I receive £1,000 into my bank account, made up of £1200 pension and -£200 income tax.

    If I enter the total amount as 1200 as pension income and -200 as income tax, it shows 1200 received into the bank. Is there a proper way to enter it, please?

    If I enter 1000 as money into bank and 200 as income tax, it shows -1200 as pension received.
     
    MAYBE record the 1200 payment (which you did get) gross and then allocatye £200 into tax account?
     
    Upvote 0

    MyAccountantOnline

    Business Member
    Sep 24, 2008
    15,215
    10
    3,300
    UK
    myaccountantonline.co.uk
    I use VT Cash book for my personal finance records and I always struggle with the right way to record income.

    I receive £1,000 into my bank account, made up of £1200 pension and -£200 income tax.

    If I enter the total amount as 1200 as pension income and -200 as income tax, it shows 1200 received into the bank. Is there a proper way to enter it, please?

    If I enter 1000 as money into bank and 200 as income tax, it shows -1200 as pension received.

    You split the transaction - you enter the £1,000 receipt (so that it is correct and matches the statement) and in the analysis you record 1,200 pension and it'll then create a second line for -£200 which you can record as Income tax. You can split any entries where a transaction relates to more than one item.
     
    • Like
    Reactions: numbersrule
    Upvote 0

    Newchodge

    Moderator
  • Business Listing
    Nov 8, 2012
    22,637
    8
    7,949
    Newcastle
    You split the transaction - you enter the £1,000 receipt (so that it is correct and matches the statement) and in the analysis you record 1,200 pension and it'll then create a second line for -£200 which you can record as Income tax. You can split any entries where a transaction relates to more than one item.
    The trouble with that is it then records 1200 pension as a negarive and 200 tax as a positive.

    It looks as if it can't be done as a single transaction. Thanks everyone for their thoughts.
     
    Upvote 0

    MyAccountantOnline

    Business Member
    Sep 24, 2008
    15,215
    10
    3,300
    UK
    myaccountantonline.co.uk
    The trouble with that is it then records 1200 pension as a negarive and 200 tax as a positive.

    It looks as if it can't be done as a single transaction. Thanks everyone for their thoughts.

    That's correct the income is a credit (minus) and the tax is a debit.

    It can definitely be done I used to use it regularly and I've just tried it too.
     
    • Like
    Reactions: Lisa Thomas
    Upvote 0

    Newchodge

    Moderator
  • Business Listing
    Nov 8, 2012
    22,637
    8
    7,949
    Newcastle
    That's correct the income is a credit (minus) and the tax is a debit.

    It can definitely be done I used to use it regularly and I've just tried it too.
    Am I just getting my brain tangled around between credit and debit on double entry?
     
    Upvote 0

    MyAccountantOnline

    Business Member
    Sep 24, 2008
    15,215
    10
    3,300
    UK
    myaccountantonline.co.uk
    • Like
    Reactions: Newchodge
    Upvote 0
    Am I just getting my brain tangled around between credit and debit on double entry?
    Yes, in double entry you CR an Income account to give a positive amount as income.
    Tax is an 'expense which takes a DR to give a positive number in that account.

    The mnemonic which I had drummed into me is DEADCLIC.

    I.e. Debit
    drawings
    expenses
    assets
    dividends

    and

    Credit
    liabilities
    income
    capital
     
    Upvote 0

    Latest Articles

    Join UK Business Forums for free business advice