Spreadsheet: 183485d1348840806-efficiently-creating-multiple-versions-of-a-template-example
Sheet: Merge Template

Check Date | Vendor | Check Number | Amount | Name | Street | City | State | Postal Code | Reference # | Customer Agreement # | Text | g/l account | business area | cost center | document number | Current Date
OCT2012 | <==Accounting Month | 2012-10-28 00:00:00 | <==Scanning Date | user id ==> | SM96643 |  |  |  | Requester ==> | [NAME] |  | JV # ==> | 79DJV036D
2009-06-16 00:00:00 | MO [PHONE] | 1 | 1 | [NAME] | 1st | WEST SUFFIELD | CT | 6093 | 10 |  |  | 23335 | F000
2009-09-02 00:00:00 | MO [PHONE] | 2 | 185.91 | [NAME] | 2nd | OAKDALE | CT | 6370 | 11 |  |  | 23335 | F000
2009-12-11 00:00:00 | MO [PHONE] | 3 | 1 | [NAME] | 3rd | ITHACA | NY | 14850 | 12 |  |  | 23335 | F000
2009-12-07 00:00:00 | PRF0000000001 | 4 | 1.72 | [NAME] | 4th | EAST HARDWICK | VT | 5836 | 13 |  |  | 23330 | F000
2009-12-01 00:00:00 | MO [PHONE] | 5 | 1.23 | [NAME] | 5th | FARMINGTON | NY | 14425 | 14 |  |  | 23335 | F000
2009-11-17 00:00:00 | PRF0000000001 | 6 | 1.34 | [NAME] | 6th | NEW YORK | NY | 10128 | 15 |  |  | 23330 | F000
2009-11-13 00:00:00 | PRF0000000001 | 7 | 1.58 | [NAME] | 7th | LANCASTER | NY | 14086 | 16 |  |  | 23330 | F000
2009-11-11 00:00:00 | MO [PHONE] | 8 | 1 | [NAME] | 8th | PROCTORSVILLE | VT | 5153 | 17 |  |  | 23335 | F000
2009-10-26 00:00:00 | MO [PHONE] | 9 | 28.24 | [NAME] | 9th | WATERTOWN | NY | 13601 | 18 |  |  | 23335 | F000
2009-10-16 00:00:00 | PRF0000000001 | 10 | 1.11 | [NAME] | 10th | [NAME] | NY | 12407 | 19 |  |  | 23330 | F000
2009-10-06 00:00:00 | PRF0000000001 | 11 | 2.35 | [NAME] | 11th | [NAME] | NY | 14472 | 20 |  |  | 23330 | F000
2009-09-25 00:00:00 | PRF0000000001 | 12 | 4.82 | [NAME] | 12th | THERESA | NY | 13691 | 21 |  |  | 23330 | F000
2009-09-11 00:00:00 | PRF0000000001 | 13 | 1.08 | [NAME] | 13th | SLINGERLANDS | NY | 12159 | 22 |  |  | 23330 | F000
2009-09-11 00:00:00 | PRF0000000001 | 14 | 1.08 | [NAME] | 14th | QUECHEE | VT | 5059 | 23 |  |  | 23330 | F000
2009-08-31 00:00:00 | DO [PHONE] | 15 | 1.37 | [NAME] | 15th | WATKINS GLEN | NY | 14891 | 24 |  |  | 23330 | F000
2009-08-26 00:00:00 | DO [PHONE] | 16 | 16.97 | [NAME] | 16th | SHELTON | CT | 6484 | 25 |  |  | 23330 | F000
2009-08-18 00:00:00 | DO [PHONE] | 17 | 10.41 | [NAME] | 17th | HUNTINGTON ST | NY | 11746 | 26 |  |  | 23330 | F000
2009-08-11 00:00:00 | DO [PHONE] | 18 | 1.08 | [NAME] | 18th | NAPLES | NY | 14512 | 27 |  |  | 23330 | F000
2009-08-10 00:00:00 | DO [PHONE] | 19 | 5.03 | [NAME] | 19th | MOUNT UPTON | NY | 13809 | 28 |  |  | 23330 | F000
2009-08-04 00:00:00 | DO [PHONE] | 20 | 11.44 | [NAME] | 20th | CORTLAND | NY | 13045 | 29 |  |  | 23330 | F000
2009-08-03 00:00:00 | DO [PHONE] | 21 | 1.4 | [NAME] | 21st | NORTH HAVEN | CT | 6473 | 30 |  |  | 23330 | F000
2009-07-28 00:00:00 | DO [PHONE] | 22 | 2.39 | [NAME] | 22nd | [NAME] | VT | 5079 | 31 |  |  | 23330 | F000
2009-07-27 00:00:00 | DO [PHONE] | 23 | 1.51 | [NAME] | 23rd | CENTRAL SQUAR | NY | 13036 | 32 |  |  | 23330 | F000
2009-07-13 00:00:00 | MO [PHONE] | 24 | 2.41 | [NAME] | 24th | EAST CHATHAM | NY | 12060 | 33 |  |  | 23335 | F000
2009-07-07 00:00:00 | DO [PHONE] | 25 | 1.8 | [NAME] | 25th | WATERFORD | CT | 6385 | 34 |  |  | 23330 | F000
2009-07-07 00:00:00 | DO [PHONE] | 26 | 1.91 | [NAME] | 26th | HUNTINGTON ST | NY | 11746 | 35 |  |  | 23330 | F000
2009-07-07 00:00:00 | DO [PHONE] | 27 | 2.82 | [NAME] | 27th | ORCHARD PARK | NY | 14127 | 36 |  |  | 23330 | F000
2009-06-30 00:00:00 | DO [PHONE] | 28 | 1.45 | [NAME] | 28th | UTICA | NY | 13502 | 37 |  |  | 23330 | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
 |  |  |  |  |  |  |  |  |  |  |  |  | F000
Stop Here! Don’t Add anymore items to this batch!
2008-03-12 00:00:00 | DO [PHONE] | 1415076 | 158.28 | 158.28 | ALLIANCE EXCAVATING, INC. |  | 1155 GAP NEWPORT PIK |  | [NAME] | PA | 19330 | 17232988638AA | REFUND OVERPAYMENT - 17232988638AA | 23330