Generating 2 rows on a different spreadsheet based on a value

[The_Pretender]

Hi All

Our accounts software accepts bulk upload of journals from excel, the format is as below:

Batch Date	Batch Description	Batch Type	Main	Location	Nat	Dept	Amount	Description	Journal Code
20/08/2019	Bank Payments August	N	164500	0000	0000	00	678.26	MOTL61	T10
20/08/2019	Bank Payments August	N	511900	0000	0910	05	- 678.26	MOTL61	T10
20/08/2019	Bank Payments August	N	164500	0000	0000	00	633.52	COML57	T10
20/08/2019	Bank Payments August	N	511900	0000	0910	05	- 633.52	COML57	T10
20/08/2019	Bank Payments August	N	164500	0000	0000	00	186.50	WELD06	T10
20/08/2019	Bank Payments August	N	511900	0000	0910	05	- 186.50	WELD06	T10
20/08/2019	Bank Payments August	N	164500	0000	0000	00	243.02	DUMP37	T10
20/08/2019	Bank Payments August	N	511900	0000	0910	05	- 243.02	DUMP37	T10

<colgroup><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>

In the above, a positive amount is a debit and a negative is a credit. In the above, our leasing liability account is 164500 while the bank account is 511900.

What I'm looking to do is prepare a leasing payments schedule that can generate these entries automatically. An example of what I mean would be the below table being our "control" where payment date and amount are entered from our bank statement:

Payment Date	Payment Amount
20/08/2019	678.26
20/08/2019	633.52
20/08/2019	186.5
20/08/2019	243.02

<colgroup><col span="2"></colgroup><tbody>
</tbody>

In another sheet in the workbook, I would then like the journal to pull the description from a separate workbook and generate the above journals, ready to be uploaded. The vast majority of our leases are different values, so 678.26 should easily pick up that it's MOTL61 as that is the only lease of that value. There are a few leases which are for the same values, but these are for related items and are always collected on the same day e.g. if we have for leases for 500 per month, all four will have different descriptions (MOTL1, MOTL2, MOTL3 & MOTL4) but all will be collected on the same day. Is there a way of including a third column above, so that if multiple payments of the same amount are collected then these will all pull across the correct references?

Payment Date	Payment Amount	If multiple entries at same value, how many?
20/08/2019	678.26
20/08/2019	633.52
20/08/2019	186.5
20/08/2019	243.02
20/08/2019	500	4

<colgroup><col span="2"><col></colgroup><tbody>
</tbody>

If any of the above could be implemented it would greatly speed up my monthly bookings, so any help with this would be much appreciated.