First, your roster may need to be cleaned up a bitâ€¦any one who has entered a â€œBusiness Nameâ€ should be verified....some officials mistakenly put their place of emplyment there when it is intended to be used when they officiate as a corporation (which is not common).
One Time Setup:
RefTown needs to know the name of the account in QuickBooks that is used to track the amounts due to the officials (vendors).
1. Admin -> Configuration â€“ Finances, OFFICIALS FINANCES, Advanced Invoice Options
2. Under QuickBooks Options, enter the name of the Accounts Payable account from QuickBooksâ€¦.if you havenâ€™t changed it to something else in QuickBooks, it should already be set as it needs to be.
Steps to import:
Repeat steps 1 & 2 as needed whenever you have a change in the roster (new names, changed names, new SSNâ€™s etc.)
The roster export/import is based on the officialâ€™s name. What this means is that you canâ€™t have two officials with the same name. If you have such a case, youâ€™ll want to make sure to use middle initials or something to distinguish between the two. This is a limitation imposed by QuickBooks using the names for importing.
Repeating 1 & 2 should not create duplicates as long as the names remain the same.
If a person changes from â€œJamesâ€ to â€œJimâ€, the 2nd roster import will create a new vendor. In QuickBooks, youâ€™ll want to merge the two back into one. To do so, in QuickBooks, edit the obsolete name to have the new name. QuickBooks will then recognize that the two are the same and will ask if you want to merge them.
Repeat steps 3 & 4 as many times as necessary, once per batch that you wish to transfer.
If you try to reimport the same batch, it will give a bunch of error message about duplicate bill numbers. It is using the invoice # from RefTown to uniquely identify each invoice so you shouldnâ€™t be able to create duplicate payments for the same invoice.
Once you do the invoice batch export/import, I strongly recommend that you publish the RefTown invoice batch and leave it alone. Any corrections should be done in a new batch. If you donâ€™t do that, youâ€™ll need to make manual adjustments to what you had imported into QuickBooks.
Once everything is imported into QuickBooks, you can â€œPay Billsâ€ (Vendors -> Pay Bills) to start your check writing process. See Quickbook documentatoin for more info.
RefTown Knowledge Base