Allocate invoice payment clearance dates to partially paid invoices Automatically

arrud14

New Member
Joined
Dec 17, 2022
Messages
14
Office Version
  1. 2021
  2. 2019
Platform
  1. Windows
Hii,
Pls help, i have table showing the customers invoices and the partial payments made against them and i want to allocate the accurate final paid date for the every invoice calculating the sum of partial payment made against the invoices

I have done the same task manually in below attached table and i want to automate the same using some conditional formula or VBA

Book2.xlsx
ABCDEFGHIJKLM
1Invoice DetailsPayment Details
2LocationInvoice DateInvoice AmountInvoice No.NamesClearence dateOutstandingFosBankingDateBank
3AMBEDKARNAGAR05.12.2022259139453074RAJAN PAL06-Dec0CHANDAN330008-DecPUNB
4AMBEDKARNAGAR06.12.2022543239468693RAJAN PAL06-Dec0CHANDAN595011-DecPUNB
5AMBEDKARNAGAR06.12.2022480639460801RAJAN PAL10-Dec0CHANDAN600012-DecPUNB
6AMBEDKARNAGAR07.12.2022255039503179RAJAN PAL10-Dec0CHANDAN390013-DecPUNB
7AMBEDKARNAGAR08.12.2022330039542391CHANDAN08-Dec0CHANDAN800014-DecPUNB
8AMBEDKARNAGAR09.12.2022344439566311CHANDAN11-Dec0RAJAN PAL1210006-DecPUNB
9AMBEDKARNAGAR09.12.2022250539566584CHANDAN11-Dec0RAJAN PAL608210-DecPUNB
10AMBEDKARNAGAR09.12.2022275139574859RAJAN PAL10-Dec0RAJAN PAL1142112-DecPUNB
11AMBEDKARNAGAR12.12.2022341139608264CHANDAN12-Dec0RAJAN PAL371113-DecPUNB
12AMBEDKARNAGAR12.12.2022480539608111CHANDAN13-Dec0
13AMBEDKARNAGAR12.12.2022270039625463CHANDAN14-Dec0
14AMBEDKARNAGAR12.12.2022360039611283CHANDAN14-Dec0
15AMBEDKARNAGAR12.12.2022422539603022RAJAN PAL12-Dec0
16AMBEDKARNAGAR12.12.2022290239603295RAJAN PAL12-Dec0
17AMBEDKARNAGAR12.12.2022429439603153RAJAN PAL12-Dec0
18AMBEDKARNAGAR13.12.2022390039685842CHANDAN14-Dec515
19AMBEDKARNAGAR13.12.2022371139671011RAJAN PAL13-Dec-52
20
21
22
Sheet1
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top