Thursday, April 19, 2012

yogi_Duplicate Data Rows For Double Entry Accounting

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #511    Apr 19, 2012     www.energyefficientbuild.com.

user adam_sirum said:
yogi_Duplicate Data Rows For Double Entry Accounting

Hi,
My company tracks employee reimbursements on google spreadsheets with each line equal to one reimbursement.  However inorder to import these reimbursements into quickbooks (double entry accounting), each reimbursement needs to be converted into 2 lines.  I don't want to use a non-array formula as there are thousands of entries and I need it to by dynamic.  Please see my example spreadsheets.  I will be forever grateful.
Thanks in advance!
Adam

---------------------------------------------------------------------
following is a solution to the problem ... I haveshown the original data rows in sheet yogi_Sheet1 and I have duplicated the rows in sheet yogi_Sheet1-Duplicate Entries

2 comments:

  1. It is really nice to have accounting background in any business. It make easier to understand the business financial flow.

    _________________
    Accountants Wakefield

    ReplyDelete
    Replies
    1. See how well he has presented the data so that lay men can also understand this.
      Accounting
      Tranfer Credits

      Delete