How to get outstanding checks into SAGE

SUGGESTED

We started SAGE in November 2014 from QuickBooks.  Our consultant brought over all trial balances at that time. 

I am trying to reconcile the November 2014 bank statement in SAGE.  Naturally some of the checks that cleared the bank are from before our transition into SAGE.

So in order to effectively reconcile the bank Statement in SAGE, I need to bring those outstanding checks in but I can't affect balances since the consultant already brought those in.

I was told to use the 1:1 Screen, entering in the check data, amt and assign it to our cash account.  When I get into the reconciliation screen, the checks are there but with a zero amount.

I am very confused on how to do this.

Parents
  • 0
    SUGGESTED

    You do enter the checks at menu 1-1, and put the checking account at the TOP of the screen.

    However down in the grid you code them all to a "clearing" account in the cash range (which will be a debit).  If you don't already have one set up, create one with the highest number available in your cash range.  To determine that, open menu 1-8 and look at the account range numbers for cash.

    If you're entries are all zero in the bank rec, you accidentally used the same account at the top and it the grid which basically offset each other which is why the checks show as zero.

    Then you have to post a fake deposit at menu 1-2,  to the same actual checking account at the top of the screen, and again down in the grid use the cash clearing account (this will be a credit).  Save this record as a type 2=cleared record.  This will allow those checks to be available for clearing without having changed your beginning bank balance.  

    If your previous entries aren't posted to period zero, you can edit them by looking them up in menu 1-3, and putting the check # in the transaction field (do NOT press enter) and then pressing F9.  F9 will search your data for that check #.  Double click down in the grid on the debit row and change it to the cash clearing account.  

    Or you can just re-enter them at menu 1-1, but the system will warn you that the check # already exists.

Reply
  • 0
    SUGGESTED

    You do enter the checks at menu 1-1, and put the checking account at the TOP of the screen.

    However down in the grid you code them all to a "clearing" account in the cash range (which will be a debit).  If you don't already have one set up, create one with the highest number available in your cash range.  To determine that, open menu 1-8 and look at the account range numbers for cash.

    If you're entries are all zero in the bank rec, you accidentally used the same account at the top and it the grid which basically offset each other which is why the checks show as zero.

    Then you have to post a fake deposit at menu 1-2,  to the same actual checking account at the top of the screen, and again down in the grid use the cash clearing account (this will be a credit).  Save this record as a type 2=cleared record.  This will allow those checks to be available for clearing without having changed your beginning bank balance.  

    If your previous entries aren't posted to period zero, you can edit them by looking them up in menu 1-3, and putting the check # in the transaction field (do NOT press enter) and then pressing F9.  F9 will search your data for that check #.  Double click down in the grid on the debit row and change it to the cash clearing account.  

    Or you can just re-enter them at menu 1-1, but the system will warn you that the check # already exists.

Children
No Data