title: Itemized bills in Word
body: <p>I'd like to generate itemized bills for a non-profit as a Word mail merge.  </p>
  
  <p>Right now, the source data is stored in Excel in a pivot-table-like structure (this wasn't my idea) with two cells (owed and paid) per item type per customer.  (Each customer has one row, and each item type has two columns).  The existing data is in this structure, but if there's a way to automatically convert it to something better, I'm open to ideas.</p>
  
  <p>I currently have a Word mail merge document generated by a Word macro that writes a Word IF field code for every pair of columns (item type).  (Not all customers have all item types, so I need IF fields to exclude the ones each customer doesn't owe).</p>
  
  <p>The problem is that only I know how to operate this system, and I no longer have time to generate all of the bills myself.</p>
  
  <p>Ideally, I'd write my own billing app (this would also solve a number of other problems), but I don't have time for that, either.</p>
  
  <p>Is there any way to (reasonably quickly) make a system to allow somewhat less technical people to do all of the billing without me?</p>
  
  <p>We've looked into QuickBooks, but it cannot import the existing transactions.</p>