Good timing, Hendrik. We just finished implementing this process with a client. It really comes down to mapping the columns in your CC statement to the fields in Odoo Expenses app. Here's easiest, albeit manual, process:
Clean up your CC statement
- Your employees don't need to see all the columns in your CC statement. Trim it down to the few columns that are meaningful to both parties. Eg: Transaction Date, Description, Total Amount, GST etc.
- Make a note of these columns. You'll need them in the next part.
Prepare an Excel file for Import into the Expenses app
- Go to the Expenses app main page.
- Ensure you have the required fields (columns) visible on the main page. You can use the Configure option on the far right of the Title columns.
- Select one or more expenses and use the Actions > Export.
- In the next dialogue box, add or delete the columns you see fit or noted in the previous section. We recommend keeping the following:
- Expense Date
- Description
- Category
- Employee
- Paid By - Employee (to reimburse) or Company
- Company
- Total
- Activities - This will awesome if you can configure it nag the employees to submit their receipts. I'm sure there are YouTube tutorials on how to do this.
- Export the Excel file. Save it as a template for future use.
- Copt-paste the columns and rows from your trimmed down CC statement into Excel file / template. Ensure the columns match the info pasted.
- Upload the updated Excel file / template into the Expenses app using the Import records option. Ensure to test the file before pushing the changes.
- After the upload, you should have the expenses on your CC statement available for employees to take action on.
Let us know if you have any questions. Thanks!