Results 1 to 9 of 9

Thread: Shareholders loans / Money martket accounts on pastel

  1. #1
    New Member
    Join Date
    Oct 2011
    Location
    George
    Posts
    4
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Shareholders loans / Money martket accounts on pastel

    Please help, shareholder confusion.

    Our partners receive commission from time to time on sales and have to pay company operating costs monthly. Each of them opened a money market account at the bank in order to transfer money to and from the business' current account. How do I process this on pastel? Do I create shareholders loan accounts or do I show their money markets as bank accounts on pastel?

  2. #2
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,979
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    Who owns the money market accounts - the business or the partners?

    From what you said, I got the impression these are financial reserves of the partners and not the business. Would that be correct?
    The trouble with opportunity is it normally comes dressed up as work.

  3. #3
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,376
    Thanks
    35
    Thanked 393 Times in 340 Posts
    An interesting setup, I must say!

    Am I correct in my understanding that the commission that each partner earns is paid in full into their respective money market accounts, and that all of it is eventually spent on company operating costs, including their own salaries?

    If so, then I would tend to rather open each money market account as a cashbook, rather than as a normal general ledger account, even if you classify each cashbook in the shareholders loan financial category.

    A cashbook makes it easier to account for VAT and it allows you to process bank reconciliations.

    Remember to process inter-cashbook transfers via a transfer account, so that both payments and receipts appear on the cashbook reports and on the bank reconciliation reports.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  4. #4
    New Member
    Join Date
    Oct 2011
    Location
    George
    Posts
    4
    Thanks
    1
    Thanked 0 Times in 0 Posts
    No, we do pay commission into their personal accounts like all the other agents, but on certain transactions they choose to leave money in the money market for the month end operating costs. It's almost like a buffer for them not to spend all their commission and not being able to pay their part of the operating costs. We also pay the PAYE/UIF and VAT expenses on each transaction into one of the money markets so that it's available end of the month when we need to pay over to SARS.

    The money markets are in the business' name, maybe it will be better if I open cashbook accounts. If I open cashbook accounts, how do I keep it in the Shareholder loan financial category?

    Thanks for the help, I am very confused about this

  5. #5
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,376
    Thanks
    35
    Thanked 393 Times in 340 Posts
    Quote Originally Posted by Smartfin View Post
    If I open cashbook accounts, how do I keep it in the Shareholder loan financial category?
    Quite simple, really.

    There are two steps in creating new cashbooks in Pastel, i.e.

    • Create a general ledger account for each new cashbook, by going to Edit...General Ledger...Accounts. Make sure you assign the new accounts as Balance Sheet accounts, and then, in your case, in the section named "Balance Sheet Financial Category", select the option named "Shareholders Loan" (usually a cashbook account would be allocated to the "Bank" financial category).
    • Set up each of the new general ledger accounts as cashbooks by going to Setup...Entry Types and, using your existing business cashbook setup as a guide, create the two lines for each of the new cashbooks.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  6. #6
    New Member
    Join Date
    Oct 2011
    Location
    George
    Posts
    4
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Pastel does not allow me to setup those accounts as shareholders loans, it says it must be an unallocated balance sheet account or a bank account.

    The other thing is, these accounts haven't been balanced before to the bank statements. The people who use to do the books made bit of a mess with things. How can I rectify these accounts to balance to the bank statement?

  7. #7
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,376
    Thanks
    35
    Thanked 393 Times in 340 Posts
    Quote Originally Posted by Smartfin View Post
    Pastel does not allow me to setup those accounts as shareholders loans, it says it must be an unallocated balance sheet account or a bank account.
    Hmmm, you are quite correct - I've just tested it! Not a big deal though, as long as you are able to identify those cashbooks, you can manually categorise them as shareholder loans in your management accounts.

    Quote Originally Posted by Smartfin View Post
    The other thing is, these accounts haven't been balanced before to the bank statements. The people who use to do the books made bit of a mess with things. How can I rectify these accounts to balance to the bank statement?
    It can probably be sorted out, but it isn't practical to tell you how to fix it on the forum. It will require a hands-on approach, with your bank statements on hand, as well as access to your Pastel database. Let me know if you would like me to assist you with this - we can arrange a preliminary TeamViewer session (no charge) so that I can assess the situation and then prepare a quote for you.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  8. Thanks given for this post:

    Smartfin (01-Nov-11)

  9. #8
    New Member
    Join Date
    Oct 2011
    Location
    George
    Posts
    4
    Thanks
    1
    Thanked 0 Times in 0 Posts
    The members will decide tomorrow if they want the money markets to be cashbooks or general ledger accounts.

    I have another question though, when they pay money into the business for operational costs (not from the money markets, but from their personal accounts) do I note it as Capital in Pastel?

  10. #9
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,376
    Thanks
    35
    Thanked 393 Times in 340 Posts
    Quote Originally Posted by Smartfin View Post
    I have another question though, when they pay money into the business for operational costs (not from the money markets, but from their personal accounts) do I note it as Capital in Pastel?

    I would create a sub-account for each shareholder under the Shareholders Loans main account.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

Similar Threads

  1. Loans from Companies to shareholders/members
    By JHolden in forum Tax Forum
    Replies: 4
    Last Post: 13-Jan-12, 03:33 PM
  2. Replies: 2
    Last Post: 14-Apr-11, 11:22 AM
  3. Help with Bank Accounts
    By eitai2001 in forum General Business Forum
    Replies: 15
    Last Post: 18-Nov-10, 08:21 PM
  4. woolworths accounts
    By murdock in forum General Business Forum
    Replies: 6
    Last Post: 17-Nov-10, 11:12 AM
  5. Do You realy need Money to make Money?
    By Theuns" in forum MLM Industry Forum
    Replies: 8
    Last Post: 22-Aug-07, 11:57 PM

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
  •