Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-9379 Accounting batches
  3. CRM-11405

Quickbooks IIF export

          Details

          • Type: Sub-task
          • Status: Done/Fixed
          • Priority: Minor
          • Resolution: Fixed/Completed
          • Affects Version/s: 4.2.6
          • Fix Version/s: 4.3.0
          • Component/s: Accounting Integration
          • Labels:

            Description

            Please continue implementing the spec at http://wiki.civicrm.org/confluence/display/CRM/CiviAccounts+Specifications+-++Batches#CiviAccountsSpecifications-Batches-.iif%28IntuitInterchangeFile%29Format that Dave D started.

            Note the attachment which contains detailed specifications for the .IIF format. Seems from Dave D's comments that he has produced a sample output that was successfully imported into QuickBooks. We are supportihgn export just of GL (General Ledger) transaction type and required associated records.

              Attachments

              1. ChartOfAccounts.IIF
                10 kB
                Joe Murray
              2. CiviAccounts (Portable).QBM
                294 kB
                Joe Murray
              3. Financial_Transactions_1_20130108190109.iif
                1 kB
                Joe Murray
              4. Financial_Transactions_1_20130117113521.iif
                2 kB
                Joe Murray
              5. Financial_Transactions_2_20130117121452.csv
                0.6 kB
                Joe Murray
              6. Financial_Transactions_6_20130115123059.iif
                1 kB
                David Greenberg
              7. Screen Shot 2013-01-15 at 12.35.30 PM.PNG
                30 kB
                David Greenberg

                Issue Links

                has patch in

                Task - A task that needs to be done. CRM-11512 Add check number and payment instrument to financial transaction table

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Done/Fixed
                is blocked by

                Bug - A problem which impairs or prevents the functions of the product. CRM-11640 Save trxn_id, payment_method_id and check_number to both contribution and financial_trxn tables

                • Major - Major loss of function.
                • Done/Fixed

                  Activity

                    People

                    • Assignee:
                      joemurray Joe Murray
                      Reporter:
                      demeritcowboy Dave D
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      4 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: