Need formula so that expense amounts input flow to appropriate GL Accounts.

[Melissa Wilson]

I have invoices that come in daily I have a spread sheet that I will put in the vendor, amount of invoice and GL account number. I need for that information to flow to the GL accounts on the right. I need a formul to have the amounts flow under the correct gl account.

6203 6204 6210 6250 6311 6312 6320 6331 6340

Vendor Amount GL Account
$100.00 6210 $100
$200.00 6312 $200
$75.00 6204 $75

Please help I have tried everything.

[alansidman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic