Import payments using bank statements

As an alternate way to upload payments in bulk to the system, you can import your nursery's bank statement. 

1. Go to eymanage > Payments & Reconciliation in the sidebar.
   
2. Click on the Bank Statement tab in the top left. 
   
3. Click on Import Bank Statement in the top right.
   
4. Click on the Select Nurseries menu to choose which nurseries to import the statement for.
5. Click   to upload a CSV file of your bank statements. Clicking on the  icon next to the uploaded file name will remove it. 
   
6. Click Next.
   
7. In the Import Settings settings, the column headings from the CSV file will be matched with the fields on the system. If the columns match the field names, they are assigned automatically. If not, you will be able to assign them yourself using the drop-down menus. Check each field before continuing to make sure all columns line up with the correct values.
   
8. Click Next.
   
9. On the Review screen, you'll see a summary of which transactions are ready to be imported, and which contain errors. You cannot import transactions with errors. Click Back to go to previous steps and correct these errors before continuing. 
   
10. When everything is ready, click Import.
11. The screen should update with the lines on the bank statement.
    
12. To delete a statement line, check the box to select a row, then click Bulk Action > Delete.

To help you with importing the correct data into the system, we provide a CSV template that you can fill out according to your bank statement. Click Import Bank Statement, then click on the Download .csv template link in the text.

Company Admin & Accounts Admin are able to import bank statements and delete statement lines.

Company Admins, Accounts Admin, Area Managers and Nursery Managers are able to reconcile the payments to the children/invoices of those they have access to. 

If you import a bank statement to All nurseries then a nursery manager for example will have visibility of all those statement lines but will only be able to reconcile to children in the nursery they have access to. 

​

Duplicate payments

eymanage has a safeguard in place against accidentally importing the same payment twice, or importing a payment that has already been added automatically from the parent app. When you complete your Import Settings and click Next, the system will check the information in the each of the assigned fields, and if it detects that there is a duplicate transaction on the system, you will get an error and the payment will be deselected. However, if you've reviewed the payment and want to upload it anyway, you're able to do so by reselecting the payment and clicking Import.

Reconciling payments

After you've imported a statement, you can reconcile it.

You are able to see the status of each statement line on the Bank Statements screen. Click on the  icon to see details of where the statement has been reconciled.

• Related Articles

• Reconciling bank statements

  After you import a bank statement into eymanage, you can reconcile it with invoices/children on eymanage. Go to eymanage > Payments & Reconciliation in the sidebar. In the Reconcile tab you can see details of all the statement lines imported to the ...

• Importing deposits

  Your nursery may receive deposit payments from a lot of parents at once. In these cases, eymanage lets you import the deposits in bulk. Click on Children in the sidebar Click on the icon in the top right to take you to the import page. Click on the ...

• Downloading statements

  You can download statements for invoices and payments as PDFs. Downloading a statement for invoices Click on Children in the sidebar. Click on a child’s name to bring up their profile. Click on the Invoices tab on the left. In the top right, click ...

• Emailing statements

  You can send statements for invoices and payments to parents for them to view and download. Emailing a statement for invoices Click on Children in the sidebar. Click on a child’s name to bring up their profile. Click on the Invoices tab on the left. ...

• Collecting payments using GoCardless (direct debit)

  If you have GoCardless set up on eymanage and parents have been connected, you can begin to collect direct debit payments from parents' accounts. You can either do this manually, or set up automatic collection. Collecting payments manually Click on ...