Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

The extra fields I use are not coming through to QuickBooks

Short answer

A custom field is empty in QuickBooks when the sync was never told to send it, the field has a different name or type on each side, or QuickBooks does not accept that field on that kind of record. Decide first which system is the master for the field, then map it and test one record.

  • Written for business owners
  • Updated
  • By Maaz Zindani, Senior Software Engineer

Does this sound like your situation?

  • The PO number, job code or note I type in my app is blank in QuickBooks.
  • The field shows on invoices but not on estimates, or the other way round.
  • It works for new records but not for ones created before.
  • The value arrives in the wrong place, such as the memo instead of the field.
  • Another tool I use wipes the field when it syncs.

Why does this happen?

  1. The sync never included the field

    Syncs send a fixed list of fields. A field you added later is not in that list unless someone added it to the mapping.

  2. Names and types do not match

    A field called Job Number in one system and Project Ref in the other is two fields. A number sent into a text field, or text too long for the destination, is dropped or rejected.

  3. The field belongs to a different kind of record

    A field defined for invoices may not exist on customers, estimates or purchase orders. The same label then appears where you expect it and nowhere else.

  4. Which system owns the value was never decided

    If two tools write to the same field, the last sync wins and the other value is wiped. This looks like a random disappearance.

  5. Existing records were never re-sent

    Mapping a field now affects new and changed records. Older ones stay blank until they are updated or sent again.

What can I do about it today?

  1. Name the field and where you type itWrite down the label in your app, the label in QuickBooks, and which kind of record you expect it on.
  2. Take one exampleA record where the value is blank in QuickBooks, with its number and date, so it can be traced.
  3. Check whether the field exists on that record in QuickBooksOpen a sample record there and see if the field appears. If it does not, the problem is setup, not the sync.
  4. Find out who else edits itAnother app, a bookkeeper or an import may overwrite the field.
  5. Do not add the same field twiceCreating a second, similarly named field makes the mapping harder. Ask first.

When should I bring someone in?

  • The field drives billing, reporting or a customer reference.
  • Several fields are involved and more than one system edits them.
  • Records created before the change need the value filled in.

How do I handle it?

  1. Agree which system owns each fieldI read the vendor's current documentation first, and every change is tried on test data before it touches your real books. One side is the master for every field, written in a short table with its name, type and the records it applies to.
  2. Add the fields to the mappingThe sync is changed to send them, with checks for type and length, so a value that cannot be accepted is reported instead of silently dropped.
  3. Test with one real recordA record is created, changed and read back from QuickBooks to prove the value arrives intact.
  4. Back-fill older recordsExisting records are updated in a controlled run after a backup, so the new field is complete across history.

The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.

What do owners ask about this?

Can any field be synced?

Not always. Whether a field can be written depends on the record type and on what QuickBooks makes available to connected apps, so the first step is to test one.

Why does it work for some customers only?

Usually the records differ: older ones were never re-sent, or they belong to a different record type that does not have the field.

Could I use the memo field instead?

It is a workable fallback for text, but it is harder to filter and report on, so use it only if the field cannot be sent.

How was this page made?

I drafted this page with AI assistance. It is general guidance for business owners, not advice for your own system. Found a mistake? Tell me.

Next step

Want this off your desk?

Send me a few lines on where things stand. I reply within 24 hours.