Excel Product Purchasing: payment due date reporting

see file uploaded with example / info.

I have a number of buyers that buy from different suppliers/brands.

Each supplier/brand offers different buying terms (P,Q,R)

I want to track total order value $ as well as understand when the invoices need to be paid (in the future). Since each of the supplier offer different payment terms I need my buyers to input the following:

- total order value / amount Col: I

- order values for delivery slots 1-3 Col: J,K,L

- date of delivery slots (there are up to 3 possible delivery dates or slots) Col: M,N,O

- payment terms in days (from delivery date) Col: P,Q,R

I then need to see a report or summary per month or week showing the total expected $ amounts to be paid

In my example above I calculate my "payment due date" (Col: S,T,U) from the two fields "expected delivery date + payment terms in day".

The $ amount to be paid at this date resp. in this month is already shown in Col J,K,L

Where I struggle is to transfort this data into a report or even graph. I should be able to immediatly filter / tell what $ amounts are due to be paid in Feb, March, April etc...

I need this as a full year or even ongoing table for the month / years to come.

Feel free to build a totally different excel, this one is just meant to illustrate which data I have and which inputs I need to make.

Many thanks - Marc

Evner: Dataindførsel, Databehandling, Excel, Finans

Se mere: important reports in accounts payable, accounts payable report format, type of reports for accounts payable, list types of accounts payable, financial reports for accounts payable, accounts payable aging report excel template, accounts payable summary report, accounts payable month end reports, excel product sheets, php date stamp file, excel countif data hourly date wise, excel export data mysql date, oscommerce product attributes payment types, urgent excel product data entry, create excel data entry form status reporting, excel product inventory, excel script copy cell data closed file, excel function morgage payment, excel product sum multiple cells, date modified file subfolder vbscript

Om arbejdsgiveren:
( 3 bedømmelser ) Bern, Switzerland

Projekt ID: #17773196

32 freelancere byder i gennemsnit $11/time for dette job


Hi Marc, Thanks for the sharing the excel file to get good idea of the description. However, the data is 2 column offset. I have referred the detailed description provided. Looking forward to discuss further in t Flere

$15 USD / time
(774 bedømmelser)

Hello! This is vibrant webtech and I was glad to see that you're looking for help for project Excel Product Purchasing: payment due date reporting. I've delivered more than 400 + projects in the last 5 years and t Flere

$10 USD / time
(285 bedømmelser)

Hello Marc, I have done very similar report tool previously, let me send you it private chat box. I have checked the attached file data and checked your requirements with this data. I have 5 years exper Flere

$8 USD / time
(419 bedømmelser)

Hi Marc, let's discuss. Thansk *****************************************************************************************************************

$10 USD / time
(254 bedømmelser)

Hi There, I can develop a perfect dynamic excel model for this purpose. You enter your data in the sheet 1, and I will create a dynamic dashboard in sheet 2 to filter any of your data with graphs and charts. I have al Flere

$12 USD / time
(229 bedømmelser)

Hello Sir Im excel VBA macro and formula Expert :) i can build spreadsheet for track your data total order like u need Sir please discuss detail of your project via chat and im able to start working today after ever Flere

$8 USD / time
(325 bedømmelser)

Hi, I have more than 14 years of Excel/VBA exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 310 projects. Please look at the feedback left by my em Flere

$11 USD / time
(176 bedømmelser)

Dear Marc, I'm interested to work in your task. I can generate the summary report using Excel VB code. Please contact me to start the work. Regards, Rajesh

$15 USD / time
(45 bedømmelser)

I can really help you in what you are looking for. I am a professional Excel expert holding years of experience in utilizing advance level tools, functions and formulas of Excel to perform advance statistical analysis, Flere

$9 USD / time
(112 bedømmelser)

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. looking to hearing from you. Kind regards

$12 USD / time
(46 bedømmelser)

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Flere

$13 USD / time
(24 bedømmelser)

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Flere

$10 USD / time
(72 bedømmelser)

HI There !! i can do it. i am very much interested to work with you on this project. Thanks Sinthia

$8 USD / time
(101 bedømmelser)
$8 USD / time
(16 bedømmelser)
$8 USD / time
(8 bedømmelser)

Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with more than 10 years of experience using SQL, queries, reports and dashboards design and construction, data wareh Flere

$15 USD / time
(5 bedømmelser)

Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satis Flere

$15 USD / time
(18 bedømmelser)

Hello there, i completed what you wanted. It calculates week for demo purposes. With a single line of code i can add calculate day, year, or ANY date range you like. We can make it appear in same sheet, we don't have t Flere

$8 USD / time
(9 bedømmelser)

Hello I would be able to help with your invoicing query: I have created similar summary pages for my personal finances which can summarise data required from specific dates so I’m sure I can implement the solution you Flere

$15 USD / time
(4 bedømmelser)

Hi There ! Your job post has caught my attention because I'm a “Data Entry” addict and I’m considering your job for me as I have these capabilities. I always respect quality, punctuality and commitment to my job. I Flere

$8 USD / time
(3 bedømmelser)