Bank beginning balances upload

SUGGESTED

We need to load uncashed checks to a new bank. Other than manually entering one batch per check, is there any way to import this information? Ty.

  • 0
    SUGGESTED

    Yes, can be done, for example, as direct bank entries.

     Bank entries screen :

    Create a single bank entry of the type you want. Add the entry, don't post it.

    File / Export - select Excel format. This will create an example Excel template.

    Test changing the example file - including new reference numbers. Close Excel. Then file / import to the bank entries screen. (Delete the test entry, don't post it)

    Once you have it working , create your bulk entries in the template and import it.