Ir al contenido
Menú
Se marcó esta pregunta
2 Respuestas
1546 Vistas

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
Mejor respuesta

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 Mejor respuesta

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
Publicaciones relacionadas Respuestas Vistas Actividad
0
mar 25
906
0
feb 25
818
3
feb 25
20125
2
feb 24
2954
3
ene 22
2413