VAT return form pull from accounts data

[makinmomb]

Sheet 1 is my accounting data pulled from accounting software
Sheet 2 is the goverment requirement for taxes

I have manually done a sample of line

I want macro to do this for me

It needs to find vouchers with narration ( VAT )
Pick the supplier name paste it column B Pick the invoice number paste it at column D
Pick the amount paste is on G , vat inclusive , I have formula on H and I which will do the breakup
Pick the date paste it in that format into E , if not formattable , pull as is
Pick the ledger of the type of expense , place it at F

I have put 3 brackets in the accounting text for the macro to understand the various pulls it needs to do

Where there is not commentary ( VAT ) those are not taxable

[makinmomb]

Anyone i request this before end day as i got present tomorrow in an interview

[Arkadi]

sorry but this is clear as mud for me...
In the example line on Sheet 2, I see a gross value (col G) of 42,500.00 but don't understand where that number comes from...
I understand what goes where (more or less), but you need to be specific about what math to use for the "amount"... is it sum of Olumn F, or is it column G? and if so, where did 42,500 come from?

[makinmomb]

14400 i meant

08/09/2017 PRINTING & STATIONERY Payment 12203.00
VAT PAYABLE 2197.00
Cash 14400.00
( VAT ) ( ZAMZAM STATIONERY SUPERMARKET ) ( 035194/002 )
08/09/2017 PRINTING & STATIONERY Payment 4237.29
VAT PAYABLE 762.71
Cash 5000.00
( VAT ) ( ZAMZAM STATIONERY SUPERMARKET ) ( 0006/000053 )

[makinmomb]

The macro needs to know only to pull records when it finds the word ( VAT )

[makinmomb]

Anyone i gotta present this tomorrow , have 8 in hand for someone to salvage my day

[makinmomb]

Oops one day past on this , anyone can handle this automation

[Arkadi]

Give this a try...

Please Login or Register  to view this content.

[makinmomb]

Arkadi , this is so nice , i hope it works for longer range