# Allocate remaining balance to multiple deduction.

#### denver_4114

##### New Member
hi there. Kindly help me to solve my problem please.

How to distribute invoices with remaining balance to the list of deduction available per CR No.

Screenshot below is the sample list and the result is on the right side:

Hope some experts will look into it and solve the issue.

thank you

denver

#### Attachments

• 12.7 KB Views: 3

#### vletm

##### Excel Ninja
denver_4114
Tested the 1st row from 'Sheet 1' ...
How do You get those DEDUCTION DESCRIPTION's from 'Sheet 1' or 'Sheet 2'?
How do You get those 'dark orange values' from 'Sheet 2'?

#### denver_4114

##### New Member
denver_4114
Tested the 1st row from 'Sheet 1' ...
How do You get those DEDUCTION DESCRIPTION's from 'Sheet 1' or 'Sheet 2'?
How do You get those 'dark orange values' from 'Sheet 2'?
View attachment 81209
awe, deduction description = that would be given from sheet2 actually. i forgot to put it in.

regarding shaded dark orange from sheet 2, that's actually one of my question. the result posted here was my daily task on my excel. to spread-out manually the remaining balance of invoices to the list of deduction given by the buyer per CR no.

like in my post: CR#102737, total purchase order was 104,384.28(sheet1;col.C), they have payment of 37,979.41(sheet1;col.D),and they have Outstanding balance of 66,404.87(sheet1;col.E). This remaining balance goes to the list of deduction given by the buyer(sheet2), for us to consider this us paid collection. And I'm doing it manually.

just wondering if you have something to recommend to make it automated.

thank you.

#### vletm

##### Excel Ninja
denver_4114
# If You ... just remember ... those R-column values are missing
... then those values are challenge.
# Could You explain other ways... more specific or so ...
... how (except manually) did You solve S7, S8 & S9 -values?
F5 seems to be same as S8 ... hmm?
>> I found those ... but ...
How to guess that rows 4...6 belongs to INVOICE 567096?
How to guess that row 7 belongs to INVOICE 567399?
How to guess that row 8… 22 belongs to INVOICE 567401?

# If something could recommend then given details should be valid and there should be clear logic.

Last edited: