Penny Rounding in Liberty Quickbook Export

This article explains how the penny rounding feature in Liberty REACT POS flows through to QuickBooks when you run Liberty Quickbook Export. If you have not set up penny rounding yet, see Cash Payment (Penny) Rounding for the setup walkthrough.

Liberty Quickbook Export does not treat penny rounding as a special case. It is handled exactly like any other POS fee: the Fee Type you created in Liberty (typically named Penny Round Up) is mapped to a G/L Account in Liberty Quickbook Export, and every rounding adjustment posts through that mapping into your QuickBooks journal entries.

Because penny rounding is implemented as a variable-amount Fee Type, each adjustment is either a positive or a negative dollar amount on the sale:

• Rounded UP (customer pays more — e.g. $10.03 rounds to $10.05): the rounding line posts as a positive amount → credit to your Penny Round Up G/L account → small income recognized in QuickBooks.

• Rounded DOWN (customer pays less — e.g. $10.02 rounds to $10.00): the rounding line posts as a negative amount → effectively debits the same income account → a small deduction that offsets prior round-ups.

With Nearest rounding (Liberty's recommended setting), the customer is equally likely to be rounded up or down, so the net balance in your Penny Round Up G/L account trends toward zero over high transaction volume. With an always-up rounding rule, you would accrue real positive income there instead.

When you open Liberty Quickbook Export, the main screen lists every Fee Type that Liberty has defined, paired with the QuickBooks G/L account it is mapped to and the G/L account type. Penny Round Up appears in the Fee Type section alongside Item Fees, Web Surcharges, Credit Card Surcharges, and any other fees you have configured.

The two fields that matter for QuickBooks export are the ones on the highlighted row:

• G/L Account. The name of the QuickBooks account that every rounding adjustment posts to. In the example above this is also called Penny Round Up, but you can name the account anything in QuickBooks (Other Rounding Income, Cash Rounding, etc.). The name just needs to match an existing account in your QuickBooks chart of accounts.

• G/L Account Type. The QuickBooks account type. Other Income is the recommended choice because penny rounding is incidental income, not a primary sales line.

These values come from the Maintain Fee Type form inside Liberty REACT POS where you originally created the Penny Round Up fee. Liberty Quickbook Export reads them at export time — it does not let you map a fee to a different account than the one set on the Fee Type. To change the mapping, edit the Fee Type in Liberty POS (More > Fee Types > Penny Round Up > Edit).

Note: If the G/L Account or G/L Account Type column is blank for any row, that fee type is not ready for export. Liberty Quickbook Export will refuse to run until every mapping has both fields filled in. The Penny Round Up fee follows the same rule.

When you run Liberty Quickbook Export, every penny-rounding adjustment from the export window's date range posts to your Penny Round Up G/L account. Two things to know about how the entries appear:

• Daily aggregation. Liberty Quickbook Export does not create one journal line per sale. Instead, all rounding adjustments on the same date that share the same G/L account are merged into a single journal line. So a day with 47 cash transactions (some rounded up, some rounded down) produces one Penny Round Up line whose amount is the net of all those adjustments. This keeps QuickBooks tidy and reconcilable.

• Standard double-entry. The Penny Round Up amount appears on one side of the journal entry; the offset hits the cash / payment-account side of the same entry, so your books balance automatically. The export keeps the same per-sale visibility in Liberty's Transaction Journal — you just see the daily totals in QuickBooks.

The result in QuickBooks: a low-activity income account that grows or shrinks by a few cents to a few dollars per day, easy to reconcile, and impossible to lose track of because every adjustment is documented on the underlying Liberty sale.

When you set Rounding Kind to Nearest in Liberty POS Setup, the rounding direction is determined by which 5¢ boundary is closer to the actual total. Over a large sample of cash transactions:

• Cents portions of .03, .04, .08, .09 round up (positive adjustment, credit to income).

• Cents portions of .01, .02, .06, .07 round down (negative adjustment, debit to income).

The math is symmetric — both ranges contain four out of ten possible cents values — so a balanced mix of transactions produces a near-zero net balance. The Penny Round Up account becomes a self-cleaning rounding bucket rather than a source of unaccounted income.

If you ever change the rounding logic to “always up” or “always down” instead of Nearest, this balance behavior changes and the account becomes real income or real expense. That choice is yours, but most stores stay on Nearest for accounting cleanliness.

Before you run Liberty Quickbook Export the first time after enabling penny rounding, do this quick check:

1. In Liberty Quickbook Export, locate the Fee Type section on the main screen.
2. Find the Penny Round Up row.
3. Confirm the G/L Account column shows the account name you expect in QuickBooks (e.g. Penny Round Up).
4. Confirm the G/L Account Type column shows Other Income.
5. If either column is blank, open Liberty REACT POS > More > Fee Types, edit the Penny Round Up fee, and fill in the missing field. Save, then return to Liberty Quickbook Export and click Refresh in the upper-right.

Once both columns are filled in, your next export will include the penny-rounding adjustments correctly.

No. From Liberty Quickbook Export's perspective, Penny Round Up is just another Fee Type. The same mapping screen, the same daily aggregation rule, the same export workflow. The only thing that makes it look different in QuickBooks is that the adjustment amounts are very small.

You can do either. Many stores create a dedicated Penny Round Up income account so they can see the rounding impact at a glance during reconciliation. Other stores map the Penny Round Up Fee Type to a general Other Income account so it merges with other miscellaneous income. There is no operational difference — pick whichever your accountant prefers.

Check these in order:

1. In Liberty POS, confirm penny rounding is enabled (More > Setup > General > Cash Payment Rounding has a Rounding Kind set, not None).
2. Confirm cash transactions actually occurred in the export date range (rounding does not apply to card or other non-cash tender).
3. In Liberty Quickbook Export, confirm the Penny Round Up row has both G/L Account and G/L Account Type filled in.
4. In QuickBooks, confirm the Penny Round Up account exists and is not hidden / inactive.

If all four are correct and you still see nothing, the most common cause is that the period had no cash sales with non-multiple-of-5 totals — i.e., every cash sale happened to land cleanly on a nickel boundary and required no adjustment.

If the account name you put in the G/L Account field on the Fee Type does not exist in QuickBooks, Liberty Quickbook Export will create it automatically on the first export, using the G/L Account Type you specified (typically Other Income). You do not have to pre-create the account in QuickBooks before mapping it in Liberty.

No. Tax is calculated on the original pre-rounding sale total and exports through your tax-rate G/L mappings unchanged. The Penny Round Up adjustment is a separate line that posts to its own income account; it has no Tax Type assigned, so it generates no tax of its own.

That usually means your rounding configuration is not symmetric. If you have Rounding Kind set to anything other than Nearest, or if you have Round To set to a value other than 5 or 10, the rounding bias can accumulate. Switch to Nearest with Round To = 5 if you want the balance to self-clean. Otherwise the balance is real and should be reviewed by your accountant.