Today, I wanted to simply share an Excel template with you for Credit Card Expenses incurred as an employee under an Accountable Reimbursement Arrangement.

I use Excel to automate repetitive things and calculations, thus saving time for staff. A couple other benefits are accurate math – much less susceptible to human error and finally, I like having an electronic file version. (I have an aversion to paper).

Features of the template:

Date submitted automatically populated

Columns:

Columns for Charge Date, Vendor Name and Amount.

Transaction Description – when the user clicks on these cells, they will see a reminder on what to include. I have customized this for what I wanted to see. You can change by going to Data then Data Validation then Input Message.

The last column features a Drop Down Menu to select the account code the transaction is coded to.

I exported the Chart of Accounts from the accounting system we had into a second tab (columns D – G) and built the table for the drop down menu in Column C by setting up a Named Range. Depending on the format your system exports in, you may need to change the formulas. (send me an email if you need help)

One last thing. You can customize by having multiple templates to segregate by department if you wanted to shrink the available accounts to choose from for example.

I have an area to paste in your church logo as well.

Download the Excel template [download id=”923″]. By subscribing, all other templates and models on the site become available to you as well.