Summarized account total in journal entries

SOLVED

Sometimes I need to use an account multiple times in one journal entry and Sage 50 Pro summarizes the account into one dollar amount when I post.  I would like to keep the detail in the journal entry and ledger.  This is particularly challenging during bank reconciliation when I use the bank account multiple times in one entry.  Is there a way keep the detail for the account after posting.

Parents
  • 0

    Assuming you are talking about an entry posted in the General Journal, then what you are asking for was put into the program about 15 years ago and is the only way the General Journal posts entries.  Which version of the program are you currently using?

    If you are talking about Purchases, Sales or other modules, they always post as one account per entry and total individual rows.  There is no way to change it.

    What type of entry are you posting to the bank account multiple times?  Cash register sales in the Sales Invoice module?

  • +1 in reply to Richard S. Ridings
    verified answer

    Thanks for replying.  I am using Sage 50 Pro 2021.  I am posting daily cash register sales using Receivable Journal.  I use bank account multiple times to record cash, debit, Mastercard and Visa sales.  Debit and credit cards amounts are automatically deposited to bank account separately which makes it challenging (and time consuming) when reconciling the bank account.  The program summarizes the bank account each day when posted but on the bank statement they are itemized.  

  • 0 in reply to [email protected]

    I was one of the instructors for the Simply Accounting Beyond the Basics courses that ran from 2003 to 2012.  In it we taught how to do daily sales in the general journal.  Below is an example of how we posted sales for a Golf course.  This is the same way I set up a dental surgeon's office who uses different software for patient management but used Simply Accounting for bookkeeping.  This works for convenience stores or any retail, etc.

    As you can see the bank is used multiple times and it will show in the journal entry as you see it here.  If you don't use one of the lines in the recurring transaction, delete the line for that day.  You never have a problem determining if you have balanced properly and you never have a bunch of zero dollar invoices in your customer aged history reports.

  • 0 in reply to Richard S. Ridings

    Thanks again, one final question, does HST show up in the monthly HST Remittance report?

  • 0 in reply to [email protected]

    If you are a user of the Sales Tax reporting and therefore have it turned on, the Sales Tax button at the bottom of the image I included in my last message will show black and active.  You will be able to click on it after you have completed your data entry and apply the appropriate sales tax code.  That code will allow it to show on your HST reporting.

Reply Children
No Data