Introduction
If you have connected your company's cards to Fyle's real-time feed with Visa or Mastercard, transactions from the cards will instantaneously flow into Fyle whenever they are made.
To learn more about Visa real-time feed, read: Managing transactions through Visa real-time feed
To learn more about Mastercard real-time feed, read: Managing transactions through Mastercard real-time feed
In rare cases, the real-time feed might not capture a transaction. Fyle offers the ability to easily validate that all transactions are present in Fyle, and import any transactions if missing.
Using statement upload to reconcile transactions
Download your credit card statement from your bank portal in CSV, XLS, or XLSX format from your bank portal.
On the Tasks page, attach the statement file by clicking on Upload.
Verify the bank name and statement period automatically extracted by Fyle. Make any changes required.
Choose the correct debit/credit convention for your statement.
Review the mappings created by Fyle for each column on your statement. Make any changes required.
Refer to the preview of the statement to ensure that the mappings are correct.
Based on the mapping, a summary is shown. This includes the % of transactions which are already present in Fyle (usually 100%). In case any transactions are not present in Fyle, they will be highlighted.
In case any such transactions are present, click on Import. This will successfully add the missing transactions to Fyle.
Best practices
We recommend you upload the entire statement received from your bank. Fyle will automatically identify the missing transactions (if any) and only import them.
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. You can read more about this here: Add cards & transactions using statement upload
By default, the value of the Preferred Reconciliation Date is set to Post Date. Based on that date, Fyle searches for matching transactions. You can change this to Transaction Date from the Mapping screen.