Click the Browse button at the right of the Import File field to locate the file from BusinessWorks.
Select the date range to import.
In the Map To column, map each BusinessWorks Account to the desired account in FCA or PBM.
Use the grid on the right side of the window to define transactions to be summarized into one transaction. Select the Summarize transactions as follows box to create the summarized transaction(s). Use the grid to define the summarized transaction as follows:
Number—Identify all parts of a summarized transaction with the same Number. The transaction number in FCA Write Up will be S1, S2, etc.
Debit—Enter the debit accounts in the Debit column that are part of the summarized transaction.
Credit—Enter the credit accounts in the Credit column that are part of the summarized transaction.
Description—Enter a description for the transaction, if desired.
FindAccounts—After a unique Number and one account in the Debit or Credit column have been entered, click on the entered Account and click Find Accounts. To use the Find Accounts button, there must only be one row with this summarized transaction Number. To use the same description on all accounts found, enter it on the first row. Delete the new row that is created, then click on the account number, then Find Accounts. The program will find all accounts associated with the entered account in past QuickBooks imports and populate the Debit and Credit columns and any description entered. Delete any rows for cash or checking accounts by clicking in the row and pressing the Delete key on the keyboard. Delete all rows containing accounts you wish to exclude from the summary.
Click OK to import the transactions.
Cancel—Click the Cancel button to close the screen without importing.
Print—Click Print to print the mapping as displayed in the grid. Due to printer variations, column widths do not print the same as they look on the screen. Use Options>Print Offset to adjust for these differences.
Export Map—Click Export Map to export the mapping displayed in the grid to a txt or csv file.
Find Accounts—The Find Accounts button is only active if you have selected Summarize transactions as follows:. See detailed instructions in Step 6 above.
Batch—Each import will be assigned a unique Batch name that follows a similar formatting pattern. Batch PBM 2020 2-1 indicates that the import is the first PBM or FCA import done in period 2 of 2020. If another file is imported in the same period using this import, the batch name would be PBM 2020 2-2.
Undo by Batch—To delete all transactions imported in a batch, select Writeup>Import Transactions>PBM or FCA. Select the Batch to be deleted in the Undo by batch field and select Undo. Batches that have been imported in prior periods cannot be undone.
Select the Batch from the Batch field drop-down list.
Additional filters may be set to zero in on particular transactions.
Notes: The file created in Business Works is a comma delimited file with data in specific columns.
Column 1—Transaction number Column 2—Date Column 3—Employee Name if Include Name is checked or could be a description if Put contact lookup in description field is checked Column 4—A description that may have a page number if the transaction is a check or invoice Column 5—Account Column 6—Amount
at the right of the Import File field to locate the file from BusinessWorks.
Comments
0 comments
Article is closed for comments.