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

Beceriler: Veri Girişi, Veri İşleme, Excel, Finans

Daha fazlasını gör: 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

İşveren Hakkında:
( 3 değerlendirme ) Bern, Switzerland

Proje NO: #17773196

Bu iş için 32 freelancer ortalamada $11/saat teklif veriyor


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 Daha Fazla

$15 USD / saat
(774 Değerlendirme)

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 Daha Fazla

$10 USD / saat
(285 Değerlendirme)

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 Daha Fazla

$8 USD / saat
(419 Değerlendirme)

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

$10 USD / saat
(254 Değerlendirme)

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 Daha Fazla

$12 USD / saat
(229 Değerlendirme)

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 Daha Fazla

$8 USD / saat
(325 Değerlendirme)

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 Daha Fazla

$11 USD / saat
(176 Değerlendirme)

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 / saat
(45 Değerlendirme)

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, Daha Fazla

$9 USD / saat
(112 Değerlendirme)

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

$12 USD / saat
(46 Değerlendirme)

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, Daha Fazla

$13 USD / saat
(24 Değerlendirme)

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 Daha Fazla

$10 USD / saat
(72 Değerlendirme)

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

$8 USD / saat
(101 Değerlendirme)
$8 USD / saat
(16 Değerlendirme)
$8 USD / saat
(8 Değerlendirme)

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 Daha Fazla

$15 USD / saat
(5 Değerlendirme)

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 Daha Fazla

$15 USD / saat
(18 Değerlendirme)

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 Daha Fazla

$8 USD / saat
(9 Değerlendirme)

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 Daha Fazla

$15 USD / saat
(4 Değerlendirme)

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 Daha Fazla

$8 USD / saat
(3 Değerlendirme)