Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Pastel Accounting

  1. #1
    New Member
    Join Date
    Jan 2009
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel Accounting

    Anybody have a solution for when the stock module and the General ledger does not balance? Also what causes this?

  2. #2
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,978
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    Assuming for a moment it wasn't a technical fault, have you looked for any non-stock module generated entries in the general ledger's stock account?

    I had the pleasure of a TB that didn't balance once with Pastel, some sort of database error due to a power blip or something, so it seems technical issues may be a possible cause. But I'd scan for a journal entry or something similar first that might have messed things up. It would just take a misallocated entry in the general ledger to cause the problem.

    EDIT: Getting the two balances to match should be as easy as passing a journal entry in the general ledger to reverse whatever caused the error. If the amount is insignificant, I'd make a post to shrinkages or something similar, make a note and let my accountants deal with it next time they visit the books.
    Last edited by Dave A; 06-Jan-09 at 10:15 PM.
    The trouble with opportunity is it normally comes dressed up as work.

  3. #3
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,978
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    An update:

    The problem applies to both Pastel and Quickbooks.

    The problem is caused by application of average cost when expensing stock as it it is sold and at valuation time. I've been looking closely at why it should be causing the error.

    First, let's understand average cost. When the price fluctuates on individual items, the accounting software has a problem assigning a cost value per item as it processes it for either a sale or stock on hand valuation. It seems the software solves this by taking all the different cost prices and assigning an average value. (I haven't plumbed the depths of the exact formula on how this average is arrived at, but it's the basic idea that needs to be understood at this point).

    The result is that with sales and stock valuation transactions, the cost price being used isn't necessarily the actual cost price of the item being sold or valued, and this results in a difference between the stock module and the stock value account in the nominal accounts ledger.

    Another factor that will aggrevate this error relates to the timing of capture. When stock arrives and is captured into the system, all sales of that item made prior to capture of the received stock for that day will essentially be expensed at the "wrong" average value.

    I can't see a viable day-to-day process solution for the problem. The only way I can suggest to resolve this is at stock take time. The accounting software allows for changes in the stock on hand. However, running the stock adjustment on quantities is not enough - you will also need to check and adjust the cost price for each stock item. Relying on the program calculated average cost just isn't cutting the mustard.

    Personally, I'll be applying the cost price per item based on the last bill received, unless there is some reason this value should not be relied on.

    This will then produce a reliable value for stock on hand in the stock module. From there post a journal entry between the stock account and whatever you are using for cost of sales to balance the value per the stock module and the stock account in the nominal ledger.
    The trouble with opportunity is it normally comes dressed up as work.

  4. #4
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,978
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    Another update.

    At the end of this financial year, I followed exactly the procedure I set out above. To be clear:
    Quote Originally Posted by Dave A View Post
    The only way I can suggest to resolve this is at stock take time. The accounting software allows for changes in the stock on hand. However, running the stock adjustment on quantities is not enough - you will also need to check and adjust the cost price for each stock item. Relying on the program calculated average cost just isn't cutting the mustard.

    Personally, I'll be applying the cost price per item based on the last bill received, unless there is some reason this value should not be relied on.

    This will then produce a reliable value for stock on hand in the stock module.
    A bit of a mission, but apart from that so far so good. But then I got to this bit:
    Quote Originally Posted by Dave A View Post
    From there post a journal entry between the stock account and whatever you are using for cost of sales to balance the value per the stock module and the stock account in the nominal ledger.
    Of course I had to check first to see what that difference might be. Guess what - it was 0. The value of stock per both systems were exactly the same.

    This was using Quickbooks. I'd be interested if anyone has tried this procedure using Pastel and what the result was.
    The trouble with opportunity is it normally comes dressed up as work.

  5. #5
    Full Member
    Join Date
    May 2009
    Location
    Fourways
    Posts
    25
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Hi

    I used to be a PCI, which means I had to knwo pastel quite well. there is a number of app out there that can fix your Problem, but the problem might not be that simple. In the past pastel has had version which posted one side journal enrties. they used to have an app called fixes, which solver some systems problems, but iof that does not help, I sued to use a DDF editor, this allowed your to access the datafiles and fix teh problem. not sure if pastel still use's DDF file, but I can't see why they woudl have changed.
    The stock problme could have also come into effect if you are suing more than 2 decimel places in the stock module, as the accounting only used 2.

    I am not sure if this helps in any why.

  6. #6
    New Member
    Join Date
    Jul 2014
    Location
    Pretoria
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Dave - Please Help

    I did a stock take end of February and after it was updated on Pastel we checked the pastel Inventory quantities 3 times. March came and gone without 1 single problem – But since April it went downhill!!! Each and every month end I have stock loss like you won’t believe! I went back and checked all my Supplier Invoices and Credit Notes as well as on the customer side. The quantities on Pastel match the mentioned documents 100%. I don’t use the function for negative quantities – Is there anything else I’m missing?

  7. #7
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,978
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    If it's a Pastel problem, we'll need someone familiar with Pastel to jump in here.

    But the impression I'm getting is what you are experiencing is a unit count problem rather than a valuation problem. Would that be right, Liana?
    The trouble with opportunity is it normally comes dressed up as work.

  8. #8
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,240
    Thanks
    207
    Thanked 310 Times in 268 Posts
    Hi liana - I am not too clued up on Pastel's Inventory side (Neville will have to help here) but if everything is matching up on the document might it not be that someone has found a way of helping themselves to your goods?
    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
    Jul 2014
    Location
    Pretoria
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the response Dave.

    I really don’t know what the problem is, but it can’t be a count problem as we double and triple check every single item that we receive and that is sent out to customers. Still the physical quantities never match the quantities on Pastel.

  10. #10
    New Member
    Join Date
    Jul 2014
    Location
    Pretoria
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the response Mike

    That is what I’m thinking as well, but I need to assure that there’s nothing I’m missing on Pastel before I start procedures with my personnel – I’m still hoping and praying that something is going wrong on Pastel.

Page 1 of 2 12 LastLast

Similar Threads

  1. pastel
    By murdock in forum Accounting Forum
    Replies: 13
    Last Post: 06-Nov-10, 08:43 AM
  2. Pastel Difficulties ?
    By Martinco in forum Accounting Forum
    Replies: 0
    Last Post: 20-Oct-08, 09:40 AM
  3. Pastel reconciling itself
    By paulnel in forum Accounting Forum
    Replies: 4
    Last Post: 25-Sep-08, 01:17 PM
  4. Pastel Accounting software won't run on Vista
    By Dave A in forum Accounting Forum
    Replies: 34
    Last Post: 23-Jul-08, 10:13 AM
  5. Accounting Systems
    By Ryss in forum Accounting Forum
    Replies: 13
    Last Post: 20-Dec-07, 10:33 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
  •