Good afternoon,
I am trying to run an expense breakdown for a particular vendor and I am unsure what is the best way to do this. I want to analyze how much each branch is spending on office supplies from Staples.
Our GL setup is as follows XX-XXXX where the first 2 digits (segment ID) signify a branch location and the last 4 (account number) signify the expense account. I.e. 01-1050 is used for branch one's office supplies expense. Purchases can include multiple branches however, so a transaction might look like the following:
Total Purchase: $500
01-1050: $200
02-1050: $150
05-1050: $150
I do not see an option in SmartList to add the transactions purchase account as a column. 'Purchases account number' seems to be restricted to the Vendor's default purchase account, and not necessarily what was used. The only way that I have been able to generate an expense breakdown is by running a trial balance for all segment ID's for a purchase account, and then looking through all transactions to find the ones for the applicable vendor. This is tedious and there has to be a better way to do this so that it is already filtered by the vendor.
Does anyone know a more efficient way to compare expenses for a specific vendor across different segment ID's? I think there should be a report to do this, but I am unsure. Your help is greatly appreciated!
-Joey
*This post is locked for comments
I have the same question (0)
