Skip to Content
Menú
This question has been flagged
2 Respostes
1648 Vistes

Hello,

I would like to import my credit card statement directly to the expense management app so that the employee can directly submit the receipts based on his company credit card expenditures. 

How should I proceed? Is this even possible ?

Thank you 

Avatar
Descartar
Best Answer

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
  1. 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.
  2. Make a note of these columns. You'll need them in the next part.
Prepare an Excel file for Import into the Expenses app
  1. Go to the Expenses app main page.
  2. 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.
  3. Select one or more expenses and use the Actions > Export.
  4. In the next dialogue box, add or delete the columns you see fit or noted in the previous section. We recommend keeping the following:
    1. Expense Date
    2. Description
    3. Category
    4. Employee
    5. Paid By - Employee (to reimburse) or Company
    6. Company
    7. Total
    8. 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.
  5. Export the Excel file. Save it as a template for future use.
  6. Copt-paste the columns and rows from your trimmed down CC statement into Excel file / template. Ensure the columns match the info pasted.
  7. Upload the updated Excel file / template into the Expenses app using the Import records option. Ensure to test the file before pushing the changes.
  8. 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!

Avatar
Descartar
Autor Best Answer

Great answer thank you. This makes sense and is certainly efficient in order to reconcile the employee's expenses with the credit card statement. 

Is there a way to create these records directly when the credit card expense happened? So with an API to the credit card.

Thanks

Avatar
Descartar
Related Posts Respostes Vistes Activitat
0
de març 25
974
0
de febr. 25
881
3
de febr. 25
20253
2
de febr. 24
3034
3
de gen. 22
2475