Questions? We have answers.

General ledger data spans multiple worksheets

Article author
Kate H
  • Updated

Summary

Learn what to do if the data you need to import spans multiple sheets in Excel.


Symptom

An error appears when an Excel file with more than one worksheet is imported.


Resolution

Solution 1

Step 1: Combine all sheets into one

  1. If the data has merged cells, unmerge them.
  2. Right click on any tab and choose Select All Sheets.mceclip0__2_.png

  3. Click the top left square (left of column A) to select all cells in all worksheets.
    mceclip1__3_.png

  4. Go to Format > Cells (keyboard shortcut Ctrl+1 on PC or command+1 on Mac).
  5. Select Alignment, and make sure that Merge cells is unchecked.Screen_Shot_2020-11-06_at_22.23.49.png

Step 2: Ensure that all worksheets are in the same format

Each worksheet must contain the exact same columns in the exact same position and order; e.g., account number in column A, account description in column B, memo in column C, debits in column D, credits in column E.

Step 3: Copy and paste the data from each worksheet into one single worksheet.

Solution #2

In the following situations, feel free to submit a data formatting request to the Customer Support team:

  • If there are too many rows to fit onto 1 Excel worksheet
  • Additional formatting needs to be done (for example, ungrouping)
  • There are many worksheets and many workbooks

Root cause

Because MindBridge can only read a single worksheet, the data found after the first worksheet is ignored.


Anything else on your mind?
Log in to MindBridge to chat with us, submit a request, or reach out to your assigned Customer Success Manager.


Related Articles

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.