Hi,
I have a spreadsheet with data pulled from an accounting system. The data reads as per the below example
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Invoice Number[/TD]
[TD]Current[/TD]
[TD]+30[/TD]
[TD]+60[/TD]
[TD]+90[/TD]
[TD]+120[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Debtor Name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Invoice Date[/TD]
[TD]123456[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Invoice Date[/TD]
[TD]123457[/TD]
[TD]10[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Invoice Date[/TD]
[TD]123458[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total Debtor Name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]30.00[/TD]
[/TR]
</tbody>[/TABLE]
I pull the report every Monday, fortnightly, and need to chase anything that is more than 14 days old - EG - report was pulled this Monday just gone, being the 22 July 2019. So any invoices dated the 8th July onwards are not considered overdue, but anything prior to the 8th is overdue and I need to contact the client for payment.
I need to somehow sort the data to remove anything that is dated from the 8th July onwards, so I'm only left with the invoices that are outstanding by more than 14 days.
Doing this manually is taking a LOT of time. Any help is appreciated.
Thanks,
Sara
I have a spreadsheet with data pulled from an accounting system. The data reads as per the below example
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Invoice Number[/TD]
[TD]Current[/TD]
[TD]+30[/TD]
[TD]+60[/TD]
[TD]+90[/TD]
[TD]+120[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Debtor Name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Invoice Date[/TD]
[TD]123456[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Invoice Date[/TD]
[TD]123457[/TD]
[TD]10[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Invoice Date[/TD]
[TD]123458[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total Debtor Name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]30.00[/TD]
[/TR]
</tbody>[/TABLE]
I pull the report every Monday, fortnightly, and need to chase anything that is more than 14 days old - EG - report was pulled this Monday just gone, being the 22 July 2019. So any invoices dated the 8th July onwards are not considered overdue, but anything prior to the 8th is overdue and I need to contact the client for payment.
I need to somehow sort the data to remove anything that is dated from the 8th July onwards, so I'm only left with the invoices that are outstanding by more than 14 days.
Doing this manually is taking a LOT of time. Any help is appreciated.
Thanks,
Sara