Feel free to experiment here, after the four dashes below. Please do not create new pages without any meaningful content just to try it out!

You may want to open HelpOnEditing in a new window or tab while you edit.

QuickBooks migration procedure to PostBooks

Export the listed reports. The format for the reports is the standard used by the 2008 version of QuickBooks.

GL Transaction
AR Open Invoices
AP Open Invoices
PR Detail

Use OpenOffice.org to open the reports. You can use their File>Open in the application or at the shell you can use:

soffice QBgltx2008Aug.CSV

Load as a standard CSV. Note that OpenOffice.org won't offer import options unless the suffix for the file is CSV or csv. Check the box for "commas" as Separators, and double quotes as text delimiters.

Open the file, then File>Save As, select CSV as the output file type, click the box to "Edit Export Parameters", select Other for Separator, enter "|" (pipe symbol), and save the file with the .pip extension to identify your delimiter.

Run the following:

awk -f awk.makeQB2PBgltx.sql QBgltx2008Aug.pip > QB2PBgltx.sql

The resulting SQL file will update the gltrans table with your historic QB data. Check the balances of the accounts, run P&L and Balance Sheet reports, and you're all set. Note that the SQL file can be huge and may take some time to process.

Formatting

italic bold typewriter

backtick typewriter (configurable)

bigger smaller this is how it works

preformatted some more
and some more lines too

   1 def syntax(highlight):
   2     print "on"
   3     return None

   1   public void main(String[] args]){
   2      System.out.println("Hello world!");
   3   }

Linking

HelpOnEditing InterWiki

http://moinmo.in/ Python

someone@example.com

There are anchor links here:

Image Link

Smileys

$/!\$ Alert

Lists

Bullet

first
1. nested and numbered
2. numbered lists are renumbered
second
third blockquote
- deeper

Glossary

Term: Definition

Drawing

Clickable drawing: mytest.png

Heading 1

Enter content
More content