Data is a powerful tool for reconciling expense. In Vendrix, you can download a Spending Report as a .xlsx file and view all of the data as an Excel spreadsheet.
Utilizing Pivot Tables are a great way to summarize, analyze and further explore data.
Utilizing Pivot Tables
Pivot Tables are an interactive way to quickly summarize large amounts of data. Within Vendrix, you can use this to categorize spending by vendor, budgets, people, dates, etc. This gives insight to spending patterns among your company.
Navigate to the Settings page within Vendrix by clicking on "Settings' on the menu bar at the left of your screen. Or by clicking on your profile icon on the top right of your screen
Scroll down to Export Spending Reports in Vendrix and select the desired timeframe: Current Month, Previous Month or Custom Period.
3. A file will download. Open the downloaded file to view in Excel Format
4. Within the Excel top menu click Insert, then click Pivot Table
5. The table/range will be selected by default as well as "New Worksheet". If not, select the tab of data as your range and New Worksheet as where to place the Pivot Table. Click OK.
6. A Pivot Table field edit box will appear to the right of your Excel window when you select within the Pivot Table. Here, you can select categories in the Field Name box that you want to show. From there, simply organize the Rows, Columns, and Values.
Reference the video for a few examples of Pivot Tables we recommend starting with.
Using the Vendrix Tag Function
Tags are assigned to every transaction within a budget and are meant to group transactions with descriptors other than the budget name. Many Vendrix users use tags to assign general ledger codes, project numbers, or project phase codes to all transactions within the same budget.
The "Tag" function in your Vendrix budget can play to your advantage when creating a Pivot Table. For example, Tag A could be a high level description like "Overhead, Accounting" or a job type. Tag B and Tag C can be utilized to further describe purchases. From there, you can categorize spend and see exactly where your dollars are going.
Vendrix is here to help make expense reports easier. Contact Vendrix to learn more about how these can benefit you!