Accupos 2012 Crack
Indira Rossetto
I have taken over a system set up by someone else. It is a small bar. They use AccuPos as their POS. The flaw in the way things were setup is that the UOM are all screwed up which results in things like -1.24mil being in a draught beer item. I have uncovered the issue and have created all new inventory and service items to work with the accupos system. where I am stumped is how to deal with all the erroneous inventory currently in the system. For the time being I have simple started putting all the bogus inventory into an adjustment writeoff account and then am planning on trying to post it into the proper places as I know that not everything will make sense. One issue is that not only are the numbers jacked but in some instances it is almost impossible to tell how much of something was actually taken.
the 1550 numbers are kind of okay as she was entering them as a keg and the price was per keg. The sales numbers are okay as the "price" was put in correctly and accupos was posting the proper sales. It is the 5010 account where it seems the issue is. It will say $24,000 in beer was sold. It seems that since it was setup so that it was a 1-1 ratio on Buy/Stock/Sell and AccuPos was told to take out 14 units from inventory that it was taking 14 kegs per beer. I am just trying to figure out the simplest and cleanest way of clearing this up. So far we figure we just need to clear out everything and pick a new starting date for inventory and largely ignore everything up to now. This started in April of 2017, so it is not worth trying to unravel this all and fix it properly.
Do discuss the situation with the accountant. Provided that inventory counts were done and adjustments correctly applied at year end, the net income and balance sheet should have been reasonably correct.
thanks for your response. Ya I have rebuilt the inventory system and where ever possible I have created the new code with an A at the end to denote adjusted. In some cases I have just had to create an all new number due to how I need to set up the inventory. For instance they buy bottled beer in 6/12/18/24 cases but sell it by the bottle, so I created an inventory item BB#### and this lets me just enter the number of bottles bought and the cost paid.
I guess what I am wondering more than anything is if putting everything into an "inventory writeoff" account and then moving it from there to the other accounts makes sense? The previous bookkeeper was making all kinds of J/E adjustments to try and fix the mess. For instance if it showed purchases of $24,000 in draught she was making an adjustment to change it to say $247. Now my issue with this is that I don't know if she actually ran the numbers right in that some of the draught seemed to be in the system fine and others didn't. So if she was just making blanket entries based on totals and not adjusting only the messed up stuff I am left chasing my tail. The other thing I don't know how to reconcile are all of the "inventory" items that have negative quantities but no value? These are ones where she had a bottle set up in inventory and then a glass also set up as an inventory item but since the glass was never "purchased" the two systems could never come up with a per unit cost. For instance the liquor gun was showing about 2 bottles worth of vodka being sold through it on volume but there was no value. So if I need to make the adjustments to inventory here I can come up with a per unit price no problem but I just don't know where to take it from? This is why I am wondering if using a write off account to put all these things into and pull them out of makes sense as this way I hopefully can make the actual accounts related to the items make sense.
As I have never used the inventory mod on sage before this is a bit of a learning experience for me too. Luckily I seem to be a much better student. I am just trying to get the flow straight in my head as to how the different accounts should look and how they should read in terms of relating to things like sales and physical inventory.
So if I have this right, you buy 15 items and they go into the 1500 account. Then you sell 5 and the sales go into 4000 and 5 goes into 5000 and out of 1500. So now your 1500 should reflect that you have 10 units still on hand. The 4000 account and the 5000 account then are used in order to show you your profit margins on things as it is showing you what how much you sold stuff for and how much what you sold cost you. I think I have all that right.
So in my case when it comes to trying to "fix" things I would need to try and find a way to adjust the purchases account in order to have any numbers that remotely make sense with regards to seeing profit/loss. So take this one draught beer where I have -$1.24mil. If I look at the "kegs" which should be ounces I can tell that there were about 442 beers sold. So there were only about 3-4 kegs of beer actually sold for a real cost of $600. If I have this right, based on how I did this I should be taking $1.24 less $600 out of the write off account and applying it to the purchases account in order to remove all the erroneous money in purchases. If all that was in this account was this beer it should then leave me with $600 in this account that would be shown as a COGS expense.
Now when it comes to the adjustments for inventory. What I don't get is how the Adjustment thing in Inventory and Services works. If I want to remove 150 units from item 1234 I pull up the adjustment thing, enter in the item number 1234, make sure the per unit cost is right and then I change the adjustment account to 5001. This then means the posting will go to the 5000 and 5001 accounts? It changes the "stock" level in 1234 but where it is actually changing things is in the "draught beer inventory" account correct?
What I am afraid of right now is that in their eagerness to get the inventory corrected that I have been forced to do things out of order and as a result I have made adjustments to the inventory based on June numbers but there are invoices that haven't yet been entered into the system from June. So it seems like I might in fact need to reverse some of these entries, input all outstanding invoices and then make adjustments as otherwise I am adjusting adjustments. What is super annoying here is that this should have been super simple if had when the person that set this all up noticed things were off fixed what was wrong rather than attempting to create work arounds using J/Es.
If you're reducing the book quantity / value because there is not as much product 1234 physically on hand as shown on the books, the quantity and $ inventory amounts are credited (reduced) from the on-hand inventory account You can see the journal entry by pressing control-J.
Because you're working with 'accrual' (as opposed to 'Cash') accounting, you work with 'cost-of-goods-sold'. Purchases go through inventory to become costs in an accrual system, while in a 'cash' system without inventory, every purchase is directly cost-of-goods-sold.
You don't / can't fix all the detail for every past transaction. Once you post inventory adjustments to actual at (or by) the end of a period, the net effect of the adjustments is to give the correct inventory value, and the correct cost-of-goods-sold.
As I said before, I'm not expert on the details of setting up AccuPOS. I would imagine that the AccuPOS software can be configured to cost multiple sales quantities and cost them back through multiple relationships to a single item. But I don't know.
We can't very effectively work through this forum in detail, it's not practical to go much beyond discussing how the features of Sage 50 work, and some general theory. Can you access someone with expertise in setting up AccuPOS?
Yes, when an inventory-linked sales transaction is posted, cost is debited to cost-of-goods-sold, and credited to the value of inventory, as well as the selling price debited to the bank / receivables / cash register and credited to sales / sales taxes
No, you can keep track of that sort of variance in a separate account, but the linked inventory Variance account is where the software will automatically record a per-item cost difference after replenishing negative inventory.
When doing a physical inventory it's important to keep track of the adjustments for shrinkage, to examine over / short quantities with an aim to learning where inventory loss is within the normal, expected range, or not.
thanks again. With the bottles of beer I just figured it would be easier to create generic inventory items for the type of beer and then enter them into the system as bottles across the board. So if we buy a 6 pack and a 12 pack I would just enter 18 bottles and put in the total amount paid and let Sage work out the per unit cost. It just seemed to make the most sense as they only sell by the full bottle. If I didn't break it down like this I would need separate buttons on accupos for each case size of beer too.
as for going back to try and fix things my idea was that I could get accupos to provide me with a monthly sales total of all units sold for Jan/Feb/Mar and then from there work out what the actual numbers should have been. So it would tell me that for instance 2000 ounces of Black Label draught was sold and I could then work out that the purchase entry for that should be $220. The sales figures are correct as they had the cost per units in and they all seem to make sense. It really just the purchases accounts and the inventory accounts that are all messed up.
what I figure is that if I know that there should have only been say $800 in draught purchases but it is showing $350,000 that I can make a J/E to correct this at the end of Jan and then do the same for Feb and Mar until I catch up to where I have fixed things. Since I dumped things into this write off account I figured that, if in the case I put forth above with the $800 in actual purchases, I move $349,200 from the write off to the draught adjustment account and then move it from the adjustment account to the purchases account to correct that account. I need to make sure this is the way that AccuPos posts things as I think that the 1500 inventory account is changed by the "charge" it creates for the sales of that day.
b1e95dc632