Bank and Credit Card Reconciliation

Follow

Comments

9 comments

  • Jeanae Remala

    Please consider adding the Bank Reconciliation field to the Journal Entry header.  This would be helpful information, as "un-associating" with bank rec is required to unpost a GL entry to change a GL Variable on it that was entered incorrectly.  (I actually field the GL variable field should be editable without unposting the entry!).

    Thanks!

    Journal Entry Detail

    1
    Comment actions Permalink
  • Ryan Faulkingham

    Hi Jeanae,

    This can be added to the JE line. If you are on the journal entry header screen, you will see the journal entry lines related list. If you edit this, you can add the bank rec field as a column. Will this work for you? 

    The reason that we don't have it on the header is because a JE can have multiple lines that are related to different bank recs. 

    Thank you,

    Ryan

    0
    Comment actions Permalink
  • 1
    Comment actions Permalink
  • Jeanae Remala

    We have approximately 40 corporate cards at this time, with the number increasing as we expand.  Does this require approach require separate General Ledger accounts for each credit card?  Also, our team is trained to enter their credit card expesnes in an "Expense Report" and attach the receipts.  Currently, you don't have any sort of similar process, correct?  Your system requires separate general ledger entries for each credit card receipt, correct?

    0
    Comment actions Permalink
  • Rebecca Ralls

    Hi Jeanae,

    There is an expense report feature that you can use for managing corporate cards - I've done it with other clients. It works quite well. You can upload their statements into the expense report format, and then they can code their own expenses and attach receipts to the expense report record.  Once approved, the expense report can be turned into a payable to be paid.

    Each user that will be coding their own expenses has to have an Accounting Seed license.  

    0
    Comment actions Permalink
  • richa

    Team,

    Is there a way for doing reconciliation in mass update? We know it's not a good idea for auditing purpose but we are curious if this could be done via excel sheet and then uploading it back.

    0
    Comment actions Permalink
  • Ryan Faulkingham

    Hi Richa,

    Currently, this must be done in the system, but we are looking to allow for open API for this reason. 

    Thank you,

    Ryan

    0
    Comment actions Permalink
  • richa

    Thanks Ryan, that will be really helpful.

    0
    Comment actions Permalink
  • richa

    Team ,

    We brought in the TB now this is being shown in the uncleared section when we generate the report.

    Is there anything that could be done here since these were reconciled in QB.

    0
    Comment actions Permalink

Article is closed for comments.