March 11, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

PO spending tracking for different vendors with similar payments

Our take

Welcome! Tracking purchase order spending for multiple vendors can seem daunting, but with a well-structured spreadsheet, it becomes manageable. You can create a single-tab layout featuring columns for vendor names, PO numbers, initial amounts, payment details, and remaining balances, all organized by month. This allows you to simply enter the date and payment amount for each vendor. Given your comfort with formulas, this setup can streamline your workflow while keeping your data organized and accessible. Let’s explore how to design this efficiently!

Hello, I'm new here, so hoping you can help. I searched but couldn't find anything similar to what I am looking for.

I am trying to create a spreadsheet that has vendor name; PO number; how much the PO started with, payment amount & date, which month it is for, how much is remaining. I'd like to keep it all on 1 tab, if possible so that the workbook doesn't get too ungainly.

Ideally, it would be set up with monthly columns/rows so that all that I have to enter is the date and amount paid for each vendor and move on. There are about 30 vendors.

I am slightly familiar with formulas (comfortable-ish) but know nothing about pivot tables.

I hope I included enough information. Thank you for any helpful guidance!

submitted by /u/EnptCoopCBus
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

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]

Tagged with

#rows.com

PO spending tracking for different vendors with similar payments

Related Articles

Tagged with