My Pencil Account
      Back to home
      1. PencilPay Help Center
      2. My Pencil Account

      How to reconcile NetSuite, your bank and PencilPay

      A quick step by step guide to reconciling your NetSuite account, your bank account and PencilPay.

      To start we need you to check the following configurations in your NetSuite account. Follow these steps:

      1. Check that the bank account that Pencil disbursement funds into is enabled to be part of reconciliations by going to:
        1. Chart of Accounts
        2. Find your bank account that the funds are disbursed into from Pencil and click Edit
        3. In the middle column check that “ USE MATCH BANK DATA AND RECONCILE ACCOUNT STATEMENT PAGES” is ticked and Save
          1. Note: If this is not possible, contact support@pencilpay.com for assistance.
      2. The next step is importing your bank feed. If you have automated bank feeds coming in skip this step and go to Step 3. 
        1. To import your bank feed file into NetSuite you can either:
          1. Search for “Upload File” in the search bar; or
          2. From the menu go to: Transactions -> Bank -> Banking Import History -> Upload File
            1. File Selection:
              1. Select your file from your computer.
              2. Note: if you don't have the template you can click on "Download the CSV template" from the right side of this page.
            2. Import Options: 
              1. Select "Import with a default parser (CSV, OFX, QFX, BAI2, or CAMT.053)"
            3. Click on Import and wait for it to complete.
      3. Next is to go to: Transactions -> Bank -> Match Bank Data
        1. Select the bank account that the funds were deposited into.
        2. Click on the Review tab.
        3. You will see a “Matched” Account Transaction from Pencil.
        4. Click on the “Submit” button in the top left of the screen to confirm this data is matched.
        5. You will see a message ‘NetSuite is confirming and clearing transactions”.
        6. To view the invoices included in the disbursement, go to “Deposits”:
          1. Find the deposit by the “Memo” which will show all the invoice numbers included.
          2. Click View.
          3. You will see in “Deposits” in the “Memo” column all the invoices included. 
          4. You can view balance of the clearing account by clicking on the Account “Pencil Clearing Account”.
          5. Here you will see all the funds in and out related to payments through Pencil.