Deposits

Overview

Making deposits is essentially the second stage in a payment workflow and a daily task in small businesses. Some businesses make bank deposits two or three times a week and some do it on a weekly basis. In general, you receive a payment from your client and record it in the Payments screen. This payment is held in the Undeposited Funds account (Other Current Asset). You can then deposit that payment into your bank account.

The Deposits screen in BQE CORE automatically presents you with all the payment transactions awaiting deposit; however, it is also possible to fill out a deposit line manually. Manually filled out deposit lines transfer funds from a source account into the destination bank account. You can also use this screen to enter direct deposits into a bank or current assets account. With the availability of check scanners and mobile phone deposits, you might make deposits several times a day even. In such cases, you need to mark multiple payments for deposits and instead of creating a single deposit transaction in the bank ledger, CORE creates a separate entry for each payment deposited. Click to watch this video on making deposits in CORE. 

You might want to segregate the deposits based on the payment method to match it to the way your bank records deposits; otherwise, bank reconciliation becomes complicated. Your bank usually records credit card deposits separately from a cash or check deposit, even if the date of the deposit is same.

From the accounting view, making deposits credits (decreases) your Undeposited Funds account and increases your income account; on the other hand, it debits (increases) your bank account.

Field Descriptions

How To

Make Deposits

Edit Deposits

Add Custom Fields

Add Documents

View Journal

Show/Hide Columns in Grid

Export Deposits

View Reports

Apply Filters

Mark Screen as Favorite

Field Descriptions

Make Deposits

To add or make a deposit, watch this video or follow these steps:

1. Open the Deposits screen from the side menu > Accounting.
   
   
   
   

2. Click Create Deposit on the top-right.

3. On the Add Deposit screen, enter the required information. Check Field Descriptions above for details.

   • Bank Account

   • Deposit Date

4. Click the Existing Client Payments sub-tab to select the existing payments from the grid.

5. Else, click the New Funds sub-tab to enter new funds in the top row of the grid. Check Field Descriptions above for details.

   • Received From

   • Payment Method

   • Amount: this is clickable and lists payment details linked to new funds 

   • From Account: account from which the payment is to be deposited

   • Class

6. Click Done and then Save & Done or Save & Add Another. 

Note: CORE allows you to add, edit, or delete deposits related to ePayments. 

Edit Deposits

You can view and edit deposits in the detail view. CORE also allows you to un-deposit any client payment that was already deposited.

To edit a deposit, watch this video or follow these steps:

1. Open the Deposits screen from the side menu > Accounting.
   
   
   
   
2. In the list view, select a deposit on the grid and click the row-action menu  to select Delete. To edit a deposit, select View Details instead.
3. On the Edit Deposit > General screen, enter more details or make changes, as needed.
   
   
4. On the Existing Client Payments tab, you can deselect a row on the left to un-deposit a payment, if needed. Clicking the Amount link on the grid opens a detail view of the Payments screen in a separate tab. This allows you to check which payments are associated with the selected deposit. (There, click Actions > View Deposits to return to the Deposits screen.)
5. Click Save & Done.

Note: CORE allows you to add, edit, or delete deposits related to ePayments.

Add Custom Fields

Using custom fields, you can track extra characteristics and attributes of your fund transfers. You can enter any information (up to 50 characters) about the transfers. You can even customize these fields in the Custom Labels screen.

To add a custom field, watch this video or follow these steps:

1. Open the Deposits screen from the side menu > Accounting.
   
   
   
   
2. In the list view, click  on the deposit row and select View Details.
3. On the Edit Deposit screen, go to the Custom Fields tab.
   
   
   
4. Click Add Custom Field and select the type of field you want depending on the purpose, say Text Box.
5. On the Add Text Box dialog, enter the required information:
   • Name
   • Type
   • # of Characters
6. Check Show in List View if you want this field to appear under the Show/Hide Columns list and show up on the grid. Click Save.

Note: You can display a maximum of three custom fields on the list view per screen.

You can also check the detailed video on managing custom fields in CORE.

Add Documents

To add a document to a deposit record, watch this video or follow these steps:

1. Open the Deposits screen from the side menu > Accounting.
   
   
   
   
2. In the list view, click   on the deposit row and select View Details.
3. On the Edit Deposit screen, go to the Documents tab and click Add.
   
   
   
   
4. On the Add Documents dialog, select the relevant tab, depending on the type of attachment.
   • Computer: To attach files stored on your computer, enter its Description and drag your file or click to browse to that location.
   • Hyperlink: To attach an external link, enter its Description and then insert the hyperlink.
   • Dropbox: To link files stored in your Dropbox account, enter its Description and then browse for it.
   • Google Drive: To link files stored in your Google Drive account, enter its Description and then browse for it.
   • OneDrive: To link files stored in your Microsoft OneDrive account, enter its Description and then browse for it.
   • Box: To link files stored in your Box account, enter its Description and then browse for it.
   • Resource Library: To link company resources, select the resource from the library. This is available in CORE CRM only.
5. Click Add.

CORE pre-fills some of the information about the attached documents in the grid. You can send the documents to your clients, employees or other contacts for getting their digital or electronic signatures (eSignature via DocuSign) using the eSign option from the  row-action menu. CORE automatically adds the signed documents to the Documents folder of the entity (record) as separate attachments. It displays the status of the document, whether it has been delivered via DocuSign, viewed by the recipients, declined or completed by the recipients, etc. This column does not show up if you are not connected via the DocuSign integration. You can also check the detailed video on managing documents in CORE.

View Journal

You can understand the accounting behind a transaction by looking at its journal entries. In CORE, you can open the Journal report to view the transaction details, including the accounts being credited or debited.

To view the journal of a deposit, watch this video or follow these steps:

1. Open the Deposits screen from the side menu > Accounting.
   
   
   
   
2. Select a deposit record on the grid and click  to select View Journal. The journal opens in the viewer.
3. Preview the journal and then choose to export or print it.

Show/Hide Columns in Grid

You can configure the fields or columns that appear on the grid in the list view. You can hide or show columns, and sort the order of columns according to your requirements.

To do so, watch this video or follow these steps:

1. Open the Deposits screen from the side menu > Accounting.
   
   
   
   
2. In the list view, click More > Show/Hide Columns on the action bar.
3. Select or un-select the column names in the drop-down list, say Ref.
4. Next, click the column you want to sort the data by, say Amount.
5. Click once for ascending order (A-Z) and twice for descending order (Z-A).

Note: You can resize the column widths on the grid and then reset them, if needed (More > Reset Column Widths).

You can also check the detailed video on navigation and customizing grids in CORE.

Export Deposits

In CORE, you can export deposits to the Comma Separated Values file format. CORE exports data from all available columns and not just the columns visible in the grid.

To export the deposits to a .CSV file, watch this video or follow these steps:

1. Open the Deposits screen from the side menu > Accounting.
   
   
   
   
2. In the list view, click More > Export as CSV.
3. A .csv export file is created and saved on your system at the default download location, say your desktop. Click to open the spreadsheet.

You can also check the detailed video on exporting data in CORE.

View Reports

To view a report, watch this video or follow these steps:

1. Open the Deposits screen from the side menu > Accounting.
   
   
   
   
2. In the list view, select a deposit on the grid and click  on that row to select View Report. This opens the Deposit Slip report in the viewer.
3. Alternatively, in the list view, click More > View Reports to select a report from the Report List dialog. It opens in the viewer.
4. Preview the report and then choose to export or print it.

You can also check the detailed video on running and managing reports in CORE.

Apply Filters

To view selective data on the grid, watch this video or follow these steps:

1. Open the Deposits screen from the side menu > Accounting.
   
   
   
   
2. In the list view, click  on the right.
3. On the Filters panel, select a filter from the drop-down and specify individual records or range.
4. Click Add Filters to specify more filters.
5. When you have finished, click Apply Filter. You can see selective data now.
6. In the list view, you can remove the individual filters by clicking  on each. To disable applied filters temporarily or remove all filters, click  next to the Filters icon and select Disable Filters or Clear All, respectively.

You can also check the detailed video on applying filters in CORE.

Mark Screen as Favorite

You can mark or flag the most-often used and important screens in CORE as your favorites up to a maximum of ten. These favorite screens then display separately on the side menu under the Favorites list. You can manage all your favorite screens in CORE from User Settings.

To mark this screen as your favorite, watch this video or follow these steps:

1. Open the Deposits screen from the side menu > Accounting.
   
   
   
   
2. In the list view, click  on the top-right.
3. You can access this screen from the side menu under Favorites.

You can also check the detailed video on marking screens as favorite in CORE.