Sometimes there are stores that sell to one another. They have to provide each other with certain supplies that the other one needs. When they do this, they are doing one another a favor. Thus, you are going to want to look at the store to store sales that you have made.
You can do all of this by keeping the sales numbers that you have come up with on your Excel program. By keeping all of this information on your spreadsheets, you are going to be able to start to manage your business finances better. Do not let anything slip through the cracks.