Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
2 Odpowiedzi
1783 Widoki

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 

Awatar
Odrzuć
Najlepsza odpowiedź

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!

Awatar
Odrzuć
Autor Najlepsza odpowiedź

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

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
0
mar 25
1095
0
lut 25
964
3
lut 25
20394
2
lut 24
3157
3
sty 22
2546