--- title: "Bulk Payments" canonical: "https://bizcore.refined.site/space/BCKB/2004910085/Bulk%20Payments" format: markdown --- > Macro (toc) # **Overview** The Bulk Payments feature allows admin users to add multiple loan repayments received externally from Biz Core’s direct debit facility into their respective loan ledgers. Any repayments that cannot be immediately attributed to a specific loan can also be added to the [Suspense Account](https://bizcore.refined.site/space/BCKB/2004844559/Suspense+Account) through the Bulk Payments feature. If borrowers make loan repayments with cash or BPay, for example, up to 500 of these transactions can be added to a single .csv file then uploaded to Biz Core where they will be applied to their respective loans or held in suspense. Transactions are added to the loan ledger on the date they are uploaded, however the system will use the transaction date of each payment supplied in the bulk upload to adjust any fees or interest splits to be accurate for when the customer’s payment was actually received by the lender. --- # **Navigating to Bulk Payments** To access the bulk payments feature, use the sidebar and navigate to **Admin Actions → Bulk Payments**: ![access-bulk-payments-from-admin.gif](media://18a212e5-a138-455a-af43-d72e7ee26453) All previous bulk uploads will be displayed as a row in a table on this page, ordered with the most recent upload at the top: ![image](media://c5e8fe8a-e2b9-42f0-b494-ec9e3470fa6f) By default Biz Core will load 20 bulk uploads per page, users can navigate between the pages or adjust how many results to display per page by using the navigation bar at the bottom: ![image](media://e9249e26-097f-47e3-8822-7e4cb3aa94e8) Columns in the table display information about the uploaded .csv, each column heading is explained below: - **Date/Time**: This reflects the date and time the upload was made. - **File Name**: This is the filename of the .csv that was uploaded. - **Count**: This will display the number of payments contained in the .csv file. - **Amount**: The total dollar amount of the payments contained in the .csv file. - **User**: The username of the user who uploaded the bulk payment file. - **View Ledger Entries**: Users can click on the **Magnifying Glass **🔍 icon to open a popup and view the ledger entries in the previously uploaded .csv file: ![image](media://d9bb51ec-a4bb-43c3-aec1-90b0dead89b5) # **Creating a Bulk Upload .CSV File** The bulk payments feature is supported by the [Suspense Account](https://bizcore.refined.site/space/BCKB/2004844559/Suspense+Account), meaning if the specific loan the payment is associated with is not immediately known the payment can still be uploaded to Biz Core, then held in suspense. Users can add a combination of both known and unknown payments to the same bulk upload file, provided they use the correct formatting for each. The only supported file type for a bulk upload is .csv, users can create this in Microsoft Excel using the following column format: ## **Format if Loan Reference is Known** The following format should be used in the .csv if the loan reference number of the payment is known to the user: - **LoanRef**: This is a required field, the string must exactly match the existing loan reference number in the system (for example: **BCL**001001A). - **Amount**: This is a required field, it must be in a number format only (for example: 10.00, not $10.00). - **PaymentType**: This is a required field, it must be either “Direct Debit”, “Direct Deposit”, “Card”, “BPay”, “Cheque”, “Cash”, or “BPoint”. - **Transaction Date**: This is not a required field, if entered it must be the current date or a date in the past. If a date is not supplied the current date will be used. This field must be formatted as DD/MM/YYYY. ### **Example .CSV File** As an example, this is the correct column formatting for a .csv file where the reference number of each loan is known to the user: ![image](media://627646fa-a5d8-4d0c-8866-268726cdd147) ## **Format if Loan Reference is Unknown** The following format should be used in the .csv if the loan reference number of the payment is unknown to the user: - **LoanRef**: This field is not required, it should be left blank so any payments where the loan reference is unknown will be added to the suspense account. - **Amount**: This is a required field, it must be in a number format only (for example: 10.00, not $10.00). - **PaymentType**: This is a required field, it must be “Suspense” - **Transaction Date**: This is not a required field, if entered it must be the current date or a date in the past. If a date is not supplied the current date will be used. This field must be formatted as DD/MM/YYYY. ### **Example .CSV File** As an example, this is the correct column formatting for a .csv file where the reference number of each loan is unknown to the user: ![image](media://f6210446-b77c-42cc-a523-2783c0d6127f) ## **Sample .CSV Download** Users can download a sample .csv file to assist with following the correct formatting from within the Bulk Payments section of Biz Core. First click the **Process Bulk Payments **:plus: icon then **DOWNLOAD SAMPLE** from the popup window: ![sample-bulk-payments-csv-download.gif](media://4b85ab34-7fcf-4b3d-9ed1-f9473f542df2) A sample .csv file will be downloaded, the user can then adjust this by removing the placeholder information and add their specific bulk payments. # **Uploading a .CSV File** After users have created their bulk payment .csv file, they can upload it by clicking the **Process Bulk Payments **:plus: icon to launch the popup window: ![open-process-bulk-payments-to-upload-csv.gif](media://b9816bbb-c957-462c-b096-ab7c51947abc) From here they click the **Choose File** button to open a file selector, locate their .csv file and click **Open**: ![image](media://9da0e12e-0b33-4f15-a785-2c73c7395a0b) After opening the file from the selector, users can upload it to Biz Core by clicking the **Upload **☁️ icon or discard it by clicking the **Bin **:cross_mark: button: ![image](media://c19d53ed-4eb3-4013-a264-7fd9027821a1) The system will display a summary of the upload: ![image](media://fee8eb77-b137-4f0d-a108-2c2937ce38a6) - **Total Count**: This is the total number of payments contained in the .csv file. - **Total Amount**: The total dollar amount of the payments in the uploaded file. - **Duplicated Records**: The total amount of duplicated records in the .csv file. To add these payment records to Biz Core users click the **PROCESS **button and confirm by clicking **YES **in the popup window: ![image](media://7b9f17b8-d179-4f82-beb0-a88496dbaf6e) Users will receive a popup notification informing them that the upload may see an error message if the process times out, and that it may take up to 15 minutes to complete the bulk payment upload: ![image](media://73c958ab-2979-466a-87ad-1cb186235d03) If the bulk upload is not immediately reflected in the list of results, users are encouraged to check back in 15 minutes and refresh the page. Once the process has completed the most recent upload will be shown at the top of the table on the Bulk Payments page: ![image](media://c6b1fcc7-d361-41ae-a71f-6c4ee4810742) # **Bulk Uploads and Loan Ledger** After uploading and processing a .csv where the loan reference number has been supplied, the respective loan ledger will be updated with an entry on the current date for the payment: ![image](media://92ef1d66-7c62-4b1c-a923-35b41247f57e) If the transaction date recorded in the .csv was earlier than the current date an adjustment ledger will also be automatically created to correct any interest or fee splits based on the date the funds were actually received by the lender: ![image](media://70329aa9-b4f3-4236-ac0c-30622841d8ec) # **Bulk Payments and Suspense Account** After uploading and processing a .csv where the loan reference number has not been supplied, the respective payment will be added to the Suspense Account. Users can [consult the documentation](https://bizcore.refined.site/space/BCKB/2004844559/Suspense+Account) for how these are handled and matched to their appropriate loan, once located.