All Collections
Fyle for Admins
Corporate Credit Card
Upload your credit card statement to import missing transactions from Real-Time Feed
Upload your credit card statement to import missing transactions from Real-Time Feed

Follow the steps mentioned here to upload the missing transactions from Visa or Mastercard cards

P
Written by Pradyumna Dinni
Updated over a week ago

With Visa and Mastercard Real-Time Feed, you get the transactions in real time on Fyle. At times, there are cases of transactions missing on Fyle owing to the card network not sending us those transactions.

For merchants like Southwest Airlines, Home Depot, Amazon, etc., we have seen the transactions not coming in from the card network while they are present on the credit card statement. While we want such issues to not occur, we are dependent on the card networks to send us these transactions.

If you or your employees have transactions present on the credit card statement but are missing on Fyle, you can upload your credit card statement to import these missing transactions. You don't have to filter out only the transactions that are missing on Fyle from your credit card statement. You can upload the whole statement and we only identify and import the missing ones on Fyle.

You can also reconcile by uploading your credit card statement to ensure all transactions are present on Fyle.

Follow the steps below:

  1. Download your credit card statement from your bank portal in CSV, XLS, or XLSX format from your bank portal where you notice transactions are missing on Fyle.

    Kindly ensure to filter only the transactions that are not present in Fyle in that CSV/XLSX.

  2. On the Tasks page, attach the statement file by clicking on Upload

  3. Drag and attach the CSV or xlsx file from your device or click on the + icon to browse the statement file from your device. Proceed to select a statement from your device and upload it onto Fyle.

  4. In the next step, we automatically take care of mapping the fields. Ensure all the fields present on the Statement are perfectly mapped with the system fields present on Fyle, including the Statement Period, etc. After checking the details, please click on Next

  5. Based on the mapping, we identify the transactions that are present on the statement but are missing on Fyle based on the card numbers and the transactions in that Statement Period. You can see a Summary screen where we show the number of transactions present on the statement, Fyle, and the list of transactions missing on Fyle.

  6. You can click on Import Transactions to import the missing transactions on Fyle. This ensures for that Statement Period, all transactions are present on Fyle.

You can watch this video for reference:

Note:

  • We recommend you upload the statement only with the transactions that are missing on Fyle for a smooth import.

  • This flow only checks for the transactions that are present on the Credit Card statement but are not present on Fyle. We don't identify the transactions present on Fyle but not present on the Credit Card statement.

  • While uploading the statement, ensure that all cards present in the statement are connected on Fyle already. If you have the cards that aren't present on Fyle yet, please upload a statement separately for those cards that are not connected to Fyle.

  • By default, the value of the Preferred Reconciliation Date is set to Post Date. Based on that date, we search for the transactions present on Fyle and identify the missing transactions on those cards. You can change this to Transaction Date from the Mapping screen.

For more information, please reach out to us at [email protected].

Did this answer your question?