Keys rarely line up perfectly. When the columns have different names, say which matches which: left_join(regions, by = join_by(region == area)). The left table's column comes first.
Some tables need two columns to identify a row, such as a store and a month. Give both: by = join_by(store, month). Joining on only one of them matches every month to every month of the same store and multiplies the rows; dplyr warns about a many-to-many relationship when that happens.
When both tables have a column with the same name that isn't a key, the result gets amount.x and amount.y. Name them yourself with suffix = c("_invoiced", "_refunded").
Different key names, a two-column key, and named suffixes.