Process bank return files

This is a process in which you get a file called a return file from your bank's website and then upload it to OnBalance. In this process, it is expected that:

  • OnBalance knows which vouchers were successfully registered at the bank.
  • OnBalance knows which vouchers were successfully canceled at the bank.
  • OnBalance automatically apply payments to installments whose vouchers were identified by the bank as paid.
  • The bank account balance is updated with those applied payments.
  • OnBalance identifies problems with registrations of issued vouchers.
  • OnBalance identifies problems with registrations of canceled vouchers.
  • OnBalance identifies problems with paid amounts by the customers.

To process the return file, follow these steps.

  1. Access your bank website and download the return rile to be processed.

    Note: Talk with your Bank Account Manager to know how to proceed on your bank's website.

  2. In OnBalance:
    1. Open the Sales screen.

    2. Click the Voucher Management button.

      Note: If you do not see this button, it is because OnBalance is not set up to issue vouchers.

    3. Click the Receive From Bank tab.
    4. Click Browse For File.
    5. Locate the downloaded file from the bank's website in a folder on your computer.
    6. Click Open.

OnBalance will process the file, performing all the actions listed at the beginning of this topic.

After you complete these steps, OnBalance will automatically open a PDF report showing the results of this process. It will also enter this same report in the report history area for later queries.

Notes

  • It is extremely important that you analyze the report, identify potential problems, and provide their solutions. To find out what each kind of error means, see Identify and resolve voucher problems.
  • If you are not sure whether you have already processed a bank file or not, you can process it again without any problem, since OnBalance is prepared to handle this situation. You may see errors like already processed vouchers or already registered vouchers in the report.