[Thinkingbig828110]

I have several gas stations that are all giving me the same issues. Each month, to account for inventory deliveries and subsequent payments, I have 3 types of invoices all provided by a third party company. The ‘Sales Invoice’ gives the gallons and price, which is straight forward. The AR Invoices are for credit card sales of gas, show a gross amount, how much if fees were remitted to the credit card companies, and then a net amount. All told there end up being 100-150 AR invoices I am supposed to use to a) determine the amount of CC fees to expense and b) use to reconcile the EFT drafts. To give you a visual, the EFT Draft statement will show a gas delivery purchase total, then a list of daily AR’s kept to pay for the gas. Since the third party company uses the CC ARs, plus a bank charge of any deficiency, to pay towards gas, I am supposed to reconcile the EFT’s using the bank statement and the AR invoices, which I am currently manually keying into Excel. While this is easy for me to do, it’s taking me too long to do all the leg work of keying in all the data in order to match the +100 AR invoices to about 10 EFT drafts each month.

Does anyone deal with a similar situation and have any advice on a way to do it to make it quicker? It’s currently taking about 2 hours to key in all the AR’s and match them against the EFT drafts and my boss is insitent that it shouldn’t take me this long, I’ve asked for advice on how to get it done faster, and he said I needed to figure it out. I’m at a loss…it’s a simple task, but tedious and time consuming to manually type in 100-200 entries.

[MrsBunny]

Another possible way is to save the pdf file as a text file (text plain) and copy the text to excel.

I still think a better solution is to contact the third party vendor to see whether they can send you the file in csv format

BEC - 80 (10/27/2010)
REG - 82 (11/30/2010)
FAR - 75 (04/01/2011)
AUD - 82 (05/27/2011)
CA Ethic - 90 (12/15/2013) * I am such a procrastinator
CPA Licensed

[Anonymous]

[Anonymous]

[Author]

Replies