Results 1 to 6 of 6

Thread: Best practice for cash sales using Pastel point of sale

  1. #1
    Full Member
    Join Date
    Nov 2012
    Location
    Cape Town
    Posts
    43
    Thanks
    5
    Thanked 1 Time in 1 Post

    Best practice for cash sales using Pastel point of sale

    Hi there

    It seems I have more questions than answers these days but I hope to be able to return the favour someday soon.

    A new client that I do bookkeeping for is using Pastel point of sale (which I have no experience with) and I would just like to know the best practice in terms of processing cash sales in Pastel Express when it is used in conjunction with Pastel Point of sale. They do the sales processing at the shop and I do the bookkeeping at my office.

    The cash sales and credit card payments are invoiced and processed through point of sale. The previous bookkeeper would capture the total cash sales for each day in the petty cash receipts cash book from the POS sales report as the cash income is not banked, and the total credit card payments for each day in the bank receipts cash book from the bank statement.

    As the cash income doesn't reflect on the bank statement, what is the most correct way (which entry type?) to capture the cash income - capturing income in a petty cash cash book is surely not the norm?

    Thanks in advance for your help.

    Regards
    Raene
    Last edited by Raene; 16-Apr-13 at 01:36 AM.

  2. #2
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    Hi Raene,

    Pastel's POS system generates all accounting entries automatically in Pastel, so there should be no need for you to capture any transactions in Xpress, unless the POS computer and the Xpress computer are not networked.

    Here are the entries that are/should be generated:

    When a sale is made, the cash sales account in the customer ledger is debited and the sales account in the income statement is credited.

    When payment is tendered, the POS Cash Control account in the balance sheet is debited and the cash sales debtor account is credited. The POS Cash Control account represents money in the till that has not yet been banked.

    When you bank takings, you will process an entry in the cashbook receipts journal for the bank, allocating it to the POS Cash Control account, thereby reducing the balance in that account.

    The above entries apply for both cash and credit card takings.

    If you use some of the cash in the till for sundry expenses, there is an option in the POS system for that, which will debit the relevant expense account and credit the POS Cash Control 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)

  3. #3
    Full Member
    Join Date
    Nov 2012
    Location
    Cape Town
    Posts
    43
    Thanks
    5
    Thanked 1 Time in 1 Post
    Thanks Neville. I now have a better understanding of how POS works.

    The thing is, I need to process the company books in my copy of pastel express so that I can do the bank recon, vat etc. In other words, I will have to duplicate all the sales/income processed through POS.

    I will capture the daily credit card total from the Daily Sales report and the EFT's from the Daily Sales Report /bank statement - in the Bank CRJ.
    I will capture the account customer invoices from the Daily Sales report - in the Customer Sales Journal - so that I can allocated payments accordingly when it comes through the bank.
    All cash sales will be captured as receipt in a new cash book which I have created and any cash out will be captured as a payment in the same cash book.

    Does this sound correct?

    Thank you

  4. #4
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    That sounds fine to me.

    So, you are creating the new cash book to represent the POS Cash Control account? And if any of that cash gets banked, then you will process a CPJ in the new cash book, allocated to a inter-cashbook transfer account, and then process a CRJ in the regular cash book, allocated to the same inter-cashbook transfer 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)

  5. Thanks given for this post:

    Raene (16-Apr-13)

  6. #5
    Full Member
    Join Date
    Nov 2012
    Location
    Cape Town
    Posts
    43
    Thanks
    5
    Thanked 1 Time in 1 Post
    Ok thank you, that's sorted then.

    I have a few more questions relating to POS.

    I see that the cash out can be paid to a supplier, customer or GL account. I assume then the GL expense account would be for items such as cleaning and staff welfare etc. Is it a problem if a supplier account has been created for all cash out payments including items that would usually be allocated to a GL account. E.g. the client has Pick n Pay set up as a supplier and allocates all staff welfare and cleaning purchases etc to that supplier account. I would however just allocate it directly to the respective GL accounts, can it be done either way?

    When a supplier pays their account (eft, cash or c/c), does one open the cash in tab and capture the payment once off like that or does one also have to process the same supplier payment in the CRJ (assuming the cash in allocation goes to the POS control account)?

    Thank you for your help. I am trying to order a POS manual from Pastel as I think I am going to need it.

    Regards
    Raene

  7. #6
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    Quote Originally Posted by Raene View Post
    I assume then the GL expense account would be for items such as cleaning and staff welfare etc.
    Correct.
    Quote Originally Posted by Raene View Post
    Is it a problem if a supplier account has been created for all cash out payments including items that would usually be allocated to a GL account. E.g. the client has Pick n Pay set up as a supplier and allocates all staff welfare and cleaning purchases etc to that supplier account. I would however just allocate it directly to the respective GL accounts, can it be done either way?
    It can be done either way. In fact, it would be better to do it the supplier account way, from a VAT point of view, as the POS system does not have the facility of accounting for input VAT when making payments to GL accounts out of the till.

    Quote Originally Posted by Raene View Post
    When a supplier pays their account (eft, cash or c/c), does one open the cash in tab and capture the payment once off like that or does one also have to process the same supplier payment in the CRJ (assuming the cash in allocation goes to the POS control account)?
    I think you meant to say "customer" instead of "supplier". If the customer pays their account in cash or cheque, and you place the cash or cheque in the till (not immediately banked), then it is preferable to process that in the POS system as "Cash In''. However, if they pay by EFT, it is better to process a CRJ in Xpress and allocate the receipt to the customer account, not to the POS Cash Control account. POS handles On-Account sales differently to Cash sales, in that the POS Cash Control account is not immediately debited when the sale is made, as no payment has been tendered at that stage.

    Quote Originally Posted by Raene View Post
    I am trying to order a POS manual from Pastel as I think I am going to need it.
    You can download an extract from the POS help file by clicking here.
    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. Import Excel into pastel Cash book
    By ultramel123 in forum Accounting Forum
    Replies: 18
    Last Post: 23-Oct-15, 09:46 AM
  2. Pastel Cash book corrections
    By ultramel123 in forum Accounting Forum
    Replies: 4
    Last Post: 09-Mar-13, 02:22 PM
  3. [Question] Pastel Cash Manager & Forms Designer
    By curare in forum Accounting Forum
    Replies: 1
    Last Post: 29-Jan-13, 03:21 PM
  4. cash sale in pastel xpress ver11
    By Naseema in forum Accounting Forum
    Replies: 2
    Last Post: 12-Jun-12, 04:30 PM
  5. [Question] Point of Sale Software - Bookshops
    By nigelm in forum General Business Forum
    Replies: 5
    Last Post: 30-Nov-10, 02:36 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
  •