My ERP system is SAP. Every month, we download budget versus actual information for analysis. The data feeds to a summary spreadsheet. To locate new general ledger account numbers that come on during month, we have a list of standard account numbers in column A in Excel 2007. We copy and paste the data out of SAP. We then check to see if new account numbers have come into play by scanning down Column A and making sure the account number in that column matches the account number in the column just downloaded.
A very manual effort to say the least.
434245 434245 Sale Cap-Vehicles
434505 434505 PY Expend Recovery
* 434 - Miscellaneous & Other
441010 441010 Signatory Landings 69,357,014.00-
441015 441015 Carrier Incentive Program 334,394.00-
441020 441020 Aviation Fuel Revenue 217,250.00-
441030 441030 Aircraft Parking Revenue 1,509,750.00-
* 441 - Landing Area 71,418,408.00-
If the account numbers don't line up, we have to figure out what was added.
Is there a simpler way to do this? I've attached an example.
Bookmarks