Automated invoice updating system
Our take
So, I have recently been tasked with fixing our costing at my restaurant job. Nothing is currently automated, I am manually updating everything.
I would like to create an Excel sheet that automatically updates a list of products from various providers with pricing and amount from invoices that we scan in
I understand that the process should work in Microsoft power automate to pull data from invoices as I add them to a folder. What I am confused about is how I can get the prices to update without adding more rows of the same product.
For example: week 1 I order 20# of chicken for $30. Week 2 I order the same product, however price has increased to $35. I would like this new information to override the old information instead of create a new line with a different cost. The PLU# would stay the same week to week so it seems like it would be doable by just overriding info that has the same PLU# I'm just not sure how I would go about doing that.
Thanks for any advice
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Price Page Automation/Efficiency Help NeededPart of what I manage in our family's company is overseeing our customer service and order entry team. We have all of our price sheets in excel files, which works well. The only problem is we have over 100 price page files now as we have at least one per customer and it becomes time consuming to update each sheet when we have price increases or decreases due to material costs. In the photo, you can see the previous pricing (2/1/2026) and the current pricing (3/8/2026). We multiply the previous case price times 1.1 if there's a 10% increase and divide that new case price by the case weight to determine price per pound. Very basic formulas. https://preview.redd.it/hnbgi9b4slvg1.jpg?width=1483&format=pjpg&auto=webp&s=cc726a1f37510165f279d404891b656ce0aa3137 What is the best way to get this automated or improve the speed of updating all of our spreadsheet? I know macros or some form of AI might be helpful but I am not familiar with macros and only use AI for basic research and problem solving. Any feedback or help would be greatly appreciated as I am trying to figure out how to keep my employees from having to work late since we are experieincing monthly price changes right now with current world events. Side note, I know we could switch to a different CRM (we have Sage 50) but that has already been shot down even though I know we could easily do price changes through the newer Sage or Netsuite. submitted by /u/CarelessSet6591 [link] [comments]
- Monthly tracking workbook I use to track employee sales metrics; Trying to find a way to make the process less labour intensiveTruly having a hard to describing my issue effectively but hoping someone can help. First time posting here and I'm by no means an expert with excel, so please be kind! I have a monthly workbook where I track each employees revenue and other metrics. Every 2 weeks for payroll, I provide a print out of these numbers, and the payroll sheet pulls data from multiple sheets in the workbook. For example, every workbook has a separate sheet for each day of the month, titled "1" through "31". I have pay period sheets, so I'll use one titled "04.02.26 - 04.15.26". Then I'll have the data for each employee pulled from multiple sheets. For example, I use the formula =SUM('2:15'!E3) to pull the sales data from each day of that period for the specific employee. This works quite well. However, when I create a new month's spreadsheet, I have to manually alter this formula for each employee and for each data point (more than just revenue, at least 6 different data points for 7 employees). Is there a way to automate this? For example, a cell or two where I'm able to enter the date range and all of the formulas update to that date range for the corresponding pages? I'm sorry of this post is confusing. Truly it's confusing even typing it! submitted by /u/Ok_Smile9222 [link] [comments]