Duplicate the row immediately above or below the row where you want to insert the new account. Replace the account range in the duplicated row with the new account number. If no number is returned on the statement, it may be because:
- The financial reporter is interpreting the account number as a "Number". Precede the account number with a "tick" (') to tell the spreadsheet it's text.
- There's no actual number to report for the period of the statement.