Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

  1. Home
  2. Knowledge Base
  3. Online Store
  4. How to Import Store transactions

How to Import Store transactions

Watch Video

Import transactions individually

Click Banking in the sidebar.


Click the Actions dropdown to the right of the Store Clearing Account.


Choose Import Transactions from the dropdown.


Select the date range then click Fetch transactions to import.


Click the Import as button next to the items you’d like to import.


Withdrawals and deposits can be imported by choosing Transaction from the dropdown.


Check that all fields are filled correctly and assign a category. The store fees category will auto-populate as a split with a negative amount.


Click Save & Close. This will take you back to the Transactions Available to Import screen.


To hide a transaction so that it doesn’t get imported, click the “eye” icon.


Bulk import transactions to the same budget category

In the import screen after transactions have been fetched, toggle Bulk Import on.


Select the transactions to be imported into the same budget category.

Click Bulk Import.


Choose a Budget Category from the dropdown.


To change the Reference and/or Paid To information to something other than what was brought in from the Store account, toggle either or both on and enter the information. Changing these fields will change it for all of the selected transactions.


Check that all of the information is correct. Click Import. This will import all of the selected transactions at once.


When funds are transferred from the Store in Cheddar Up to your bank account, this can be imported as a transfer or the transfer can be entered manually.


Click Banking in the sidebar


Click the Actions dropdown to the right of the Store Clearing account.


Choose New Transfer from the dropdown.


The From bank account should be the Store Clearing account. The To bank account should be the account the money was deposited into, i.e. checking account.

Fill in the details and click Save.


Note: If you have bank integration, deposits from Cheddar Up can be imported as transfers rather than manually recorded.


Bulk Delete transactions from a bank register

To bulk delete transactions, navigate to the bank register and toggle on Bulk Delete.


Select the transactions to be deleted. (Note: only transactions that are not reconciled can be deleted)


Click Delete selected transactions at the bottom of the page.


Note: After being deleted, imported transactions will reappear on the import page, where they can be reimported or hidden.


Back to the top

Was this article helpful?

Related Articles

4 Comments

  1. Sandra Halbrook

    If we take a cash payment in the cheddar up app, it imports but says “Transaction handled outside of Cheddar Up”. I can understand why I can’t import the cash transaction but is there a way to hide it or otherwise address it, so it doesn’t keep coming up as a transaction available to import?

    1. Traci Hahn

      Hi Sandra,

      Yes, you can hide those transactions in the import screen by clicking the “eye” symbol to the left of the import button.

  2. Jennifer

    Is there a way to mass import transactions into one category? For instance we run a store for a fundraiser, and within that fundraiser the purchaser can purchase multiple items from different item types. When it is time to import the transactions we have to manually go through each sale and then manually assign the category for each item purchased. This is time consuming. Is there an easier, less time consuming way to do this?

    1. Traci Hahn

      Hi Jennifer,

      There are a couple of things you could consider in this situation.

      First, if you make your budget category names in MoneyMinder the same as the item names in your Cheddar Up store, the budget categories will auto-full when importing. You will still import each transaction individually, but the budget category will auto-fill which can save time.

      The second thing you might consider is if you don’t need to track the details of each item, but only want to track the amount you make on the fundraiser, you can decide NOT to import each transaction from your Cheddar Up Store. Instead, you can just record the deposit in your bank account when you move the money from Cheddar Up and apply the whole deposit to the fundraiser category. This way it will all be applied to the fundraising category in one deposit instead of many individual transactions.

      Which option you choose will depend on how much detail you would like to capture.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Need Support?

Can't find the answer you're looking for?
Contact Support