How to Link Multiple Bank Accounts to the F10 Bank Worksheet
Overview of the F10 Bank Worksheet
The F10 Bank worksheet in Workpapers Excel is a powerful tool for managing bank and credit card reconciliation tasks efficiently. Using this feature, you can link multiple accounts to a single worksheet for unified tracking and analysis.
Steps for Linking Multiple Accounts to an F10 Bank Worksheet
To link multiple bank or credit card accounts to the same F10 Bank worksheet, follow either of these steps:
Accept Recommendations in the Trial Balance Screen - If recommendations for a bank workpaper appear in the trial balance view, accept them to reuse the same F10 Bank worksheet for all linked accounts.
Manually Link Another Account Using 'Add Record' - Open the trial balance or workpapers view and navigate to the relevant account line. - If no F10 Bank record exists for the account, use the Add Record action > Insert a F10 Bank worksheet (or preferably link to existing F10 Bank worksheet). - For accounts with existing records, access the workspace menu (e.g., by clicking more options/three dots on the account line on the right) to add an additional record > link to an existing worksheet.
Common Troubleshooting Tips
If Bank accounts don't appear to insert into the Bank sheet correctly, Delete the F10 Bank record from all Bank accounts until the F10 bank worksheet is fully deleted. Then accept or insert a fresh Bank workpaper against all bank accounts.
Note that it is not possible to delete a bank account from he F10 Workpaper once it has been inserted. Follow the steps above if you wish to start over.
Limitations of the F10 Bank Worksheet
Importing bank feeds or individual transactional data directly into the F10 Bank worksheet is not supported.
To ensure accurate reconciliation, attach bank statements as supporting documents for linked bank accounts to compliment the F10 Bank workpaper.
Conclusion
By following these steps, users can link multiple accounts efficiently to a single F10 Bank worksheet, streamlining their reconciliation process in Workpapers Excel. Keeping the limitations in mind, such as unsupported features like transactional imports, ensures a smooth experience when using this functionality.