Our website (not affiliated with Square) used a misspelled category name. When I run the item sales report, these items have "None" as the category. How do I add a category to these transactions?
Hello @OVQGAnna. If it is a closed transaction, Square does not allow for anything to be changed. There are no exceptions to this long-standing policy. You can, of course, manually adjust sales in your bookkeeping software, but Square reports will be wrong for these transactions.
Thinking outside the box.. what if I were to add the misspelled category to Square? Would that allow the missing items to pull into the square reports properly?
@OVQGAnna in this case, probably not. The issue is with the fact that the third-party website sent a mismatched category to Square. Square did not recognize it, so saved the transaction with category “none.” Since Square did not save the invalid category name it received adding that misspelled name now will still not change the transaction. As I said earlier, your only recourse is to correct things in your accounting and then live with the fact that your accounting will be slightly off of your Square reports. These sorts of discrepancies are very common and are almost always handled by notes and adjustments in our accounting systems which are ultimately the final say, especially as far as the IRS is concerned.
Hello @OVQGAnna !
Unfortunately there's not a way to go back and alter past transactions. Once they're closed they're permanently stored in the system.
Depending on your integration, if you've updated the category name all new orders should report correctly going forward. As for those "None" transactions, the only real way to adjust them for your books is in your accounting software.
Wish I had better news!
Square Community
Square Products