Enable Role Permission

To allow a role to use the Misc Deposit import type:

1. Navigate to Settings > Roles.
2. Click the caret next to the role to which you want to add this permission and ensure the Security tab is selected.
3. Go to the Import section and click Edit next to Misc Deposit.
   The Edit Role Security screen opens.
4. Select Append, and then click Save changes.
   This role will now see Misc Deposit as an option when selecting the Import Type on the New Import screen.

Import Misc Deposits

Review the "Import Basics" article for instructions about how to import data into Vanataca.

Prepare the Import File

Download the Misc Deposits template and enter the relevant data.

You can also find the template attached to the end of this article and available from the "Import Templates" article".

The import template includes the following fields:

• GroupID: This field is not in the spreadsheet but is added by the system during the initial upload. The number indicates the group that the item was sorted into and displays as part of the spreadsheet for review.
• PostDate: Displays the date that the miscellaneous deposit posted.
• AssocCode: Displays a valid association code.
• GLCode: Displays a GL Code for the association. This code must be a valid and previously used GL Code for the association. If the code is unused when imported, the system marks the code as used. If it doesn't exist, you will be prompted to create it. 
• Debit/Credit: Displays one of the following options:

  • D = Debit

  • C = Credit

• Amount: Displays the amount of the debit/credit.
• (Optional) Description: You can include a description, for example, to indicate what the debit/credit was for.
• (Optional) CheckNo: You can include a check number, for example, if the credit was paid with a check.
• (Optional) Fund: You can include the fund category.

Import the File

Before you begin the import, ensure that the import files are balanced (the debit and credit amounts must match). Only debits with a GL that exists in the association's bank accounts are accepted.

To import miscellaneous deposits:

1. Navigate to Settings > Import, and then click the Imports tab.
2. Click New Import.
   The New Import screen opens.
   
   
   
   
3. Select the following options:

   • Import Type: Misc Deposit.

   • Import Mode: Append.

   • Import File: Click Select files, select your Misc Deposit template file, and upload it.
     The file contents display in the Spreadsheet tab of the Import screen with any errors shown in orange. The following example shows an imported Misc Deposit file that includes one error. Note the Group ID column that shows the group number of the item.
     
     
     
     

4. Make any needed changes to resolve errors, update data, etc.
   Note: You can manually edit the GroupID field to change the grouping.
5. Click Save changes to refresh the page and save the changes.
6. When complete, click Commit.
7. To download the committed spreadsheet, click Download in the Misc Deposit row (this button appears after the import is committed).