Results 1 to 10 of 10

Thread: Banking accounts on Income statements

  1. #1
    New Member
    Join Date
    Nov 2017
    Location
    Weltevreden Park
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Banking accounts on Income statements

    Good Morning Everybody,

    I am new to work with Pastel Accounting and need some advise on opening additional cash books for investment.

    Was asked to open new cash book on the Income Statement for investment portfolios transactions. Additional to this was asked to a balance the new cash book to an already existing cash book on the balance sheet.


    Can somebody advise on how to correctly set-up the cashbook (income statement) and balancing portion to the existing cash book on the Balance Sheet.

  2. #2
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,227
    Thanks
    207
    Thanked 309 Times in 267 Posts
    Hi ChristianR - what version of Pastel are you using?
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

  3. #3
    New Member
    Join Date
    Nov 2017
    Location
    Weltevreden Park
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good Afternoon Mike,

    Pastel Partner V17

  4. #4
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,227
    Thanks
    207
    Thanked 309 Times in 267 Posts
    Hi Christina,

    If I remember correctly there is supposed to be a much easier way to add a Cash Book from version 17 onwards, but I can't remember how.

    Here is an excerpt from Neville Bailey (our Pastel guru) on the procedure.

    After creating the general ledger account for a new cashbook, you need to do the following:

    Go to Setup...Entry Types
    Scroll down to the next available empty row
    In the "Description" column, type in CB* Payments (where * represents the cash book number)
    In the "DC" column, type in D
    In the "Account Access" column, click on the drop-down arrow and select "GL and Suppliers"
    In the "Date/Period Entry" column, leave the default setting (Period Defaults Date)
    In the "Cash Book" column, type in the cash book number, or click on the drop-down arrow and select the next available number
    In the "Currency" column, leave the default setting as "Home Currency" (unless you are using foreign currency)
    In the "Bank Account" column, type in the new general ledger account that you had previously created for this cash book
    On the next row, in the "Description" column, type in CB* Receipts (where * represents the cash book number)
    In the "DC" column, type in C
    In the "Account Access" column, click on the drop-down arrow and select "GL and Customers"
    In the "Date/Period Entry" column, leave the default setting (Period Defaults Date)
    Repeat the above steps for the other cash books that you wish to setup

    Click on OK
    And here is a link if you want to download a pdf with pictures.

    https://www.ritzy.co.za/wp-content/....Cash-Books.pdf
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

  5. #5
    New Member
    Join Date
    Nov 2017
    Location
    Weltevreden Park
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good Morning Mike C,

    Thank you very much for the help, I will definitively do the cash book this way.

  6. #6
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,227
    Thanks
    207
    Thanked 309 Times in 267 Posts
    Hi Christina - the second part of your question involved balancing the new cash book with another one.

    For this you will need a "transfer control account" - eg 9800/000 Trf Control Account - Other current liabilities.

    This is simply and "in" and "out" account for cashbook transfers and so the in and out will always cancel each other out and the Control Account will remain at zero.

    You then post out (as a payment) from the one Cash Book to this Control Account and post the same amount in (Receipts) to the new Cash Book from the same Control Account.
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

  7. #7
    New Member
    Join Date
    Nov 2017
    Location
    Weltevreden Park
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Banking Accounts on Income statements

    Good Afternoon Mike C,

    Thank you for your input. Unfortunately creating an Cash book on the Income Statement still seems to be the problem. I have created the GL account via: Edit, General Ledger Accounts route. Have tried all the categories from Unallocated Income Statement to Dividends and the report writer category on bank, dividends and none, but when trying to create the cashbook, are blocked out - "The account's Financial category you have selected is incorrect." Then referred to the Balance Sheet categories.

    Any further advise?

  8. #8
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,227
    Thanks
    207
    Thanked 309 Times in 267 Posts
    Hi Christina.

    Cash Books are normally assigned to the "B60 - Bank" Financial Category.
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

  9. #9
    New Member
    Join Date
    Nov 2017
    Location
    Weltevreden Park
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good Morning Mike C,

    Just wanted to say thank you! for your input. It is good to have a platform to get some help and input.

  10. #10
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,227
    Thanks
    207
    Thanked 309 Times in 267 Posts
    My pleasure.
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

Similar Threads

  1. Replies: 290
    Last Post: 28-Jun-13, 09:31 PM
  2. banking
    By murdock in forum General Chat Forum
    Replies: 48
    Last Post: 31-Oct-11, 10:49 AM
  3. Banking at its best!
    By Dave A in forum Business Finance Forum
    Replies: 0
    Last Post: 15-Oct-08, 07:52 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •