Book1.xlsx | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |||
1 | Sheet 1 | Sheet 2 | Sheet 3 | ||||||||||||||||
2 | Account No. & Account Name | Date | Counterparty | Text | Debit | Credit | Account No. | Account Name | Balance (Debit) | Balance (Credit) | Date | Account No. (Debit) | Account No. (Credit) | Amount | Text | ||||
3 | |||||||||||||||||||
4 | 1200 AccountName1200 | 1200 | AccountName1200 | Balance1200Debit | Balance1200Credit | 1/5/22 | 1200 | 2000 | Amount1 | Text1 | |||||||||
5 | 1/5/22 | 2000 | Text1 | Amount1 | 1250 | AccountName1250 | Balance1250Debit | Balance1250Credit | 1/6/22 | 1250 | 2500 | Amount2 | Text2 | ||||||
6 | 2/18/22 | 3600 | Text4 | Amount4 | [to be continued] | [to be continued] | [to be continued] | [to be continued] | 2/12/22 | 1250 | 3100 | Amount3 | Text3 | ||||||
7 | 3/3/22 | 3400 | Text5 | Amount5 | 2/18/22 | 1200 | 3600 | Amount4 | Text4 | ||||||||||
8 | 4/12/22 | 2500 | Text7 | Amount7 | 3/3/22 | 3400 | 1200 | Amount5 | Text5 | ||||||||||
9 | 5/5/22 | 2000 | Text10 | Amount10 | 3/13/22 | 3300 | 1250 | Amount6 | Text6 | ||||||||||
10 | [to be continued] | [to be continued] | [to be continued] | [to be continued] | [to be continued] | 4/12/22 | 1200 | 2500 | Amount7 | Text7 | |||||||||
11 | 1250 AccountName1250 | 4/14/22 | 2500 | 1250 | Amount8 | Text8 | |||||||||||||
12 | 1/6/22 | 2500 | Text2 | Amount2 | 5/4/22 | 1250 | 2400 | Amount9 | Text9 | ||||||||||
13 | 2/12/22 | 3100 | Text3 | Amount3 | 5/5/22 | 2000 | 1200 | Amount10 | Text10 | ||||||||||
14 | 3/13/22 | 3300 | Text6 | Amount6 | [to be continued] | [to be continued] | [to be continued] | [to be continued] | [to be continued] | ||||||||||
15 | 4/14/22 | 2500 | Text8 | Amount8 | |||||||||||||||
16 | 5/4/22 | 2400 | Text9 | Amount9 | |||||||||||||||
17 | [to be continued] | [to be continued] | [to be continued] | [to be continued] | [to be continued] | ||||||||||||||
18 | [to be continued] | ||||||||||||||||||
19 | |||||||||||||||||||
20 | |||||||||||||||||||
21 | Text in black = formulas are already ok | ||||||||||||||||||
22 | Text in green = formulas that I cannot find | ||||||||||||||||||
Sheet1 |