Results 1 to 5 of 5

Thread: pastel express sales journal

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

    pastel express sales journal

    Hi all you Pastel experts. Need some advice on a Sales journal. In all other companies I worked at, was always straight forward invoicing. easy peasy.... But now i have two companies with a independent point of sale - retail companies . This is all new. installed Pastel - so no figures on the system yet. ... I want to bring the sales figures in as a total amount of sales generated at the shops, and purchases for the goods sold at the shop. I hope I am being clear? What is the best way to do this? General Journal? - what are your debits and credits if so? Sales journal - also presents a problem because it ask for a debtors account?
    just can not get my head around this? I would appreciate all your expert advice.

  2. #2
    Bronze Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    122
    Thanks
    0
    Thanked 26 Times in 23 Posts
    If you aren't using Pastel to track stock at all (ie kept in POS system), you can bring in sales and purchases journals directly to the relevant GL Sales and COS accounts. Create a "Cash Sales" debtor - raise the sales with VAT against that, and your banking / credit card receipts will also go against the 1 debtor. Create your suppliers and bring in 1 line item to COS Purchases GL account - payments will be made to individual suppliers. You will have to do a regular stock take to get a closing stock figure, to get an accurate Cost of Sales figure at month end.

    If you are tracking stock in Pastel, you will need to create the items, bring them in on supplier invoice / GRN, then get a 'Day End" report of all items sold from the POS. You will then create 1 invoice a day to the same "Cash Sales" debtor, and raise the total quantity and selling price for all items sold that day, to keep stock in balance.

  3. #3
    New Member
    Join Date
    Oct 2019
    Location
    Grahamstown
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Very helpful Kevin thank you

    Quote Originally Posted by Kevin Smith View Post
    If you aren't using Pastel to track stock at all (ie kept in POS system), you can bring in sales and purchases journals directly to the relevant GL Sales and COS accounts. Create a "Cash Sales" debtor - raise the sales with VAT against that, and your banking / credit card receipts will also go against the 1 debtor. Create your suppliers and bring in 1 line item to COS Purchases GL account - payments will be made to individual suppliers. You will have to do a regular stock take to get a closing stock figure, to get an accurate Cost of Sales figure at month end.


    If you are tracking stock in Pastel, you will need to create the items, bring them in on supplier invoice / GRN, then get a 'Day End" report of all items sold from the POS. You will then create 1 invoice a day to the same "Cash Sales" debtor, and raise the total quantity and selling price for all items sold that day, to keep stock in balance.

    kevin you are a star!! thank you so much. This has been super helpful. I thought i was loosing my mind. Exactly what i did but wasnt sure it was correct. We not going to keep physical stock items on pastel It will be tracked by the point of sale at the shop but just stock figures at month end. Can I ask one more question regarding stock please ? ... For opening stock figure which accounts are debited and credited? and after second stock take to i post just a variance ?

  4. #4
    Bronze Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    122
    Thanks
    0
    Thanked 26 Times in 23 Posts
    Normally you would have a balance sheet stock control account. The initial stock purchased (opening stock/stock on hand) would have been Cr Supplier and Dr Stock on hand (BS). The rest of your purchases would then go to COS (IS). When you perform stock take, the difference between Stock on hand (opening stock) and your current stock value after stock take would then be a Dr or Cr to stock on hand (BS) and the contra entry would go to an income statement account (Cost of Sales - Closing stock)

  5. #5
    New Member
    Join Date
    Oct 2019
    Location
    Grahamstown
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Kevin thank you so much for all your help. I feel a bit more confident now that you have confirmed how what and where. Really you are a great help !!

Similar Threads

  1. [Question] Sales journal import error-pastel express v18
    By Marisav in forum Accounting Forum
    Replies: 4
    Last Post: 31-May-19, 12:18 PM
  2. [Question] Pastel Inventory Journal
    By RianaGreeff in forum Accounting Forum
    Replies: 1
    Last Post: 21-Oct-16, 06:03 AM
  3. [Question] Pastel Sales Journal
    By Dientjie in forum Accounting Forum
    Replies: 5
    Last Post: 17-Jun-15, 01:27 PM
  4. [Question] Journal posting in pastel v11
    By kabaye in forum Accounting Forum
    Replies: 6
    Last Post: 06-May-14, 03:01 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
  •