Saving to a text file

QuickBooks lets you save a report, list, register, or deposit summary to a text file. You can save these items in the following formats:

File format Description
Text
(space-delimited)
Basic text file with spaces between columns. If you use this file with word processing software, use a non-proportional type font (such as Courier) to make the columns align as they do on the report or list.
Tab-delimited Basic text file with tabs between columns. It is easy to bring a tab-delimited text file into a spreadsheet or word processor application.
Comma-delimited Comma-delimited text file, with commas between columns, and with quotes around text but not around amounts.

To save to a text file:

  1. Display the item you want to save.
  2. Choose File > Save as Text (the menu item name will include the type of item you are saving, like Save List as Text).
  3. Enter a name for the file, and choose the folder where you want to save the document.
  4. Choose a text-delimited format: Tabs, Commas, or Spaces.
  5. If you chose Spaces in step 4, specify the number of columns per line and the number of lines per page.

    When lines per page are 0, the text file prints without page breaks. When you specify lines per page, your text file will have a page break after each group of lines of the number you specify. Each “page” in the text file has a title, and any other header or footer information, such as column headers and page numbers. There are no margins when you print to a file.

  6. Choose how many pages to save.
  7. Click Save.