Deltek Vantagepoint Help

Using the Help Search

Miscellaneous Tab of the Bank Reconciliation Form

Use the Miscellaneous tab to enter miscellaneous bank transactions on the statement, such as interest amounts (or other credits) and service charges (or other debits), that are not linked to a bank code.

If you enter miscellaneous charges via journal entries, you must add those charges manually to Bank Statement Reconciliation on this tab.

Contents

Field	Description
Bank reconciliation search	Use the field next to the form title to search for and select an existing bank reconciliation to view or edit. Click the filter drop-down arrow on the left side of the search field, and select one of the following search types: In Progress: Select from a list of all open bank reconciliations to which you have access. Closed: Select from a list of all closed bank reconciliations to which you have access. All: Select from a list of all bank reconciliations to which you have access. [saved custom search filter]: Select a previously saved custom filter to display the bank reconciliations returned by that custom search. Custom: Display the Custom Search dialog box. You can then create and apply a new custom search filter, which you can save for future use. For information about creating and using searches, see the Search `Vantagepoint` help topics.
x of x	Use these arrow icons to scroll through the billing labor rate tables and open a different record on the form. The numbers show you which record you are viewing out of the total number of records in the search results.
+ New Bank Reconciliation	Click this option to create a new bank reconciliation.
	Click the Switch to List View icon to switch to the list view of the form. In this view, fields are displayed in columns in one grid on the form rather than on separate tabs. Table name records are displayed in each row in the grid. This makes it easy to compare and update multiple records at one time because you do not have to open individual records. You can add, remove, or change the order of the columns in the grid by clicking to the right of the grid. This opens the List View Settings dialog box. Click to filter the grid contents based on column values. For information about how the filter works, see Filter the Grid Results. For information about selecting columns, see Select Columns for a Grid. For more information and instructions on how to use list view, see Use the List View.
	After you have switched to list view, click the Switch to Detailed View icon to switch back to the detail view of the form. Detail view is the default view that displays when you open a form for the first time; thereafter, the view that was active when you closed the application will display when you open. The detail view is the format that is described in help topics in the Help system.
<Bank Name and Code> - <Statement Date> (<Statement Number>), Fiscal Period, <Active Company>	These fields display the bank name, bank code, and statement date for the bank reconciliation, followed by the fiscal period in which the bank statement was created. If `Vantagepoint` is set up for multiple companies, the name of the active company also displays.
Import Transactions	Click this option to import new bank transactions to the bank reconciliation. This option only appears if you select the Import Enabled check box from the Options tab of the Banks form in Settings > Cash Management > Banks.
Other Actions/Actions	If you have the Import function enabled, this appears as Other Actions. Otherwise, it displays as Actions. Choose an option from the drop-down list: Close Statement: This option displays if the current bank reconciliation state is still in progress. When the reconciliation is completed, select this option to mark the reconciliation as closed. Closing a reconciliation removes the statement date from the list of "in progress" statements on the Bank Statement Selection dialog box, to make it easier to select statements in the future. It also disables options on the other tabs on the Bank Reconciliation form. However, you can choose Reopen Statement at any time to reopen the reconciliation. Reopen Statement: This option displays if the current bank reconciliation record is closed. When the reconciliation is closed, select this option to reopen the reconciliation. Reopening a reconciliation moves the statement back to the "in progress" state, which allows you to make changes and view the reconciliation. Create Transaction Entries: Click this option to create bank statement entries for bank fees, interest, and other user-defined bank entries in Settings > Cash Management > Banks. Print: Select this option to generate the Bank Reconciliation report for the currently displayed reconciliation. Errors Report: Select this option to import a report that identifies any errors that were encountered during the last import that you performed for the statement currently open in Bank Reconciliation. Import History: Select this option to open the Import History dialog box and view or undo imported bank transactions. You can undo transactions if you have imported them into the wrong bank statement.

Miscellaneous Grid

Field	Description
Other Actions	Click the drop-down arrow on a grid header to complete any of the following actions: To print grid data, click Print. On the Print Preview form, click File > Print to send the grid data to your default printer. To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally. To turn on grouping for a grid, click Enable Grouping. When a field displays with the instruction: "`Drag a column header here to group by that column`," drag and drop column headers into the field, in the sequence that you want them to display. Not all options are available on all grids.
Date	Specify the date of the charge.
Description	Enter the description of the charge.
Amount	Enter positive amounts to account for interest or other credits. Enter negative amounts to account for service charges or other debits. For example, if you have a $60.00 service charge (entered as -60.00) and a $50.00 interest amount (entered as 50.00), $10.00 is subtracted from the opening balance when accounting for these items in calculating the closing balance. When you enter a miscellaneous amount, it is added to the Miscellaneous line of the Cleared Items summary.
	This icon displays at the end of the row when you click or hover over a grid row. Click the icon to select one of these actions for that row: Delete: Select this option to delete the miscellaneous entry. Copy: Select this option to copy the miscellaneous entry details as a new miscellaneous entry.
+ Add Row	Click this option and enter a date, description, and amount to create a new miscellaneous transaction entry. Press ENTER or click outside the row to add the new entry to the grid.

JavaScript must be enabled in order to use this site.Please enable JavaScript in your browser and refresh the page.

Miscellaneous Tab of the Bank Reconciliation Form

Use the Miscellaneous tab to enter miscellaneous bank transactions on the statement, such as interest amounts (or other credits) and service charges (or other debits), that are not linked to a bank code.

If you enter miscellaneous charges via journal entries, you must add those charges manually to Bank Statement Reconciliation on this tab.

Contents

Field	Description
Bank reconciliation search	Use the field next to the form title to search for and select an existing bank reconciliation to view or edit. Click the filter drop-down arrow on the left side of the search field, and select one of the following search types: In Progress: Select from a list of all open bank reconciliations to which you have access. Closed: Select from a list of all closed bank reconciliations to which you have access. All: Select from a list of all bank reconciliations to which you have access. [saved custom search filter]: Select a previously saved custom filter to display the bank reconciliations returned by that custom search. Custom: Display the Custom Search dialog box. You can then create and apply a new custom search filter, which you can save for future use. For information about creating and using searches, see the Search `Vantagepoint` help topics.
x of x	Use these arrow icons to scroll through the billing labor rate tables and open a different record on the form. The numbers show you which record you are viewing out of the total number of records in the search results.
+ New Bank Reconciliation	Click this option to create a new bank reconciliation.
	Click the Switch to List View icon to switch to the list view of the form. In this view, fields are displayed in columns in one grid on the form rather than on separate tabs. Table name records are displayed in each row in the grid. This makes it easy to compare and update multiple records at one time because you do not have to open individual records. You can add, remove, or change the order of the columns in the grid by clicking to the right of the grid. This opens the List View Settings dialog box. Click to filter the grid contents based on column values. For information about how the filter works, see Filter the Grid Results. For information about selecting columns, see Select Columns for a Grid. For more information and instructions on how to use list view, see Use the List View.
	After you have switched to list view, click the Switch to Detailed View icon to switch back to the detail view of the form. Detail view is the default view that displays when you open a form for the first time; thereafter, the view that was active when you closed the application will display when you open. The detail view is the format that is described in help topics in the Help system.
<Bank Name and Code> - <Statement Date> (<Statement Number>), Fiscal Period, <Active Company>	These fields display the bank name, bank code, and statement date for the bank reconciliation, followed by the fiscal period in which the bank statement was created. If `Vantagepoint` is set up for multiple companies, the name of the active company also displays.
Import Transactions	Click this option to import new bank transactions to the bank reconciliation. This option only appears if you select the Import Enabled check box from the Options tab of the Banks form in Settings > Cash Management > Banks.
Other Actions/Actions	If you have the Import function enabled, this appears as Other Actions. Otherwise, it displays as Actions. Choose an option from the drop-down list: Close Statement: This option displays if the current bank reconciliation state is still in progress. When the reconciliation is completed, select this option to mark the reconciliation as closed. Closing a reconciliation removes the statement date from the list of "in progress" statements on the Bank Statement Selection dialog box, to make it easier to select statements in the future. It also disables options on the other tabs on the Bank Reconciliation form. However, you can choose Reopen Statement at any time to reopen the reconciliation. Reopen Statement: This option displays if the current bank reconciliation record is closed. When the reconciliation is closed, select this option to reopen the reconciliation. Reopening a reconciliation moves the statement back to the "in progress" state, which allows you to make changes and view the reconciliation. Create Transaction Entries: Click this option to create bank statement entries for bank fees, interest, and other user-defined bank entries in Settings > Cash Management > Banks. Print: Select this option to generate the Bank Reconciliation report for the currently displayed reconciliation. Errors Report: Select this option to import a report that identifies any errors that were encountered during the last import that you performed for the statement currently open in Bank Reconciliation. Import History: Select this option to open the Import History dialog box and view or undo imported bank transactions. You can undo transactions if you have imported them into the wrong bank statement.

Miscellaneous Grid

Field	Description
Other Actions	Click the drop-down arrow on a grid header to complete any of the following actions: To print grid data, click Print. On the Print Preview form, click File > Print to send the grid data to your default printer. To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally. To turn on grouping for a grid, click Enable Grouping. When a field displays with the instruction: "`Drag a column header here to group by that column`," drag and drop column headers into the field, in the sequence that you want them to display. Not all options are available on all grids.
Date	Specify the date of the charge.
Description	Enter the description of the charge.
Amount	Enter positive amounts to account for interest or other credits. Enter negative amounts to account for service charges or other debits. For example, if you have a $60.00 service charge (entered as -60.00) and a $50.00 interest amount (entered as 50.00), $10.00 is subtracted from the opening balance when accounting for these items in calculating the closing balance. When you enter a miscellaneous amount, it is added to the Miscellaneous line of the Cleared Items summary.
	This icon displays at the end of the row when you click or hover over a grid row. Click the icon to select one of these actions for that row: Delete: Select this option to delete the miscellaneous entry. Copy: Select this option to copy the miscellaneous entry details as a new miscellaneous entry.
+ Add Row	Click this option and enter a date, description, and amount to create a new miscellaneous transaction entry. Press ENTER or click outside the row to add the new entry to the grid.