top of page
Digital Rings

Important Notes about Setup

New-User Notes

  • The reporting tool is a highly automated advanced Excel file unlike you are used to seeing. There are no spreadsheets you need to manage.

​​

How to setup data source folders 

  • Pick a place on your device to add a folder called "Clearspend", then share the file path with us.

  • Of the following folders, place as subfolders the ones that are relevant to you, each under your Clearspend folder. Use the following names exactly as written below. Each name will represent a different subfolder.

 

ISRAELI

  • card-Max     

  • card-Isra

  • card-Cal

​

 

  • bank-Leumi

  • bank-Mizrahi

  • bank-Mercantile

  • bank-Hapoalim 

  • bank-Habenleumi

  • bank-Pagi

  • bank-Massad

  • bank-Otzarhachayal

  • bank-Yahav 

  • bank-Doar

  • bank-Discount

​​

NON ISRAELI

  • card-Amex        •  card-Discover

  • card-Chase       •  card-Citi

  •  card-Cap1

​

  • bank-TD                 •  bank-Capital1

  • bank-Discover         •  bank-Amex

  • bank-OfAmer          •  bank-USB

  • bank-Citi                •  bank-Chase

  • bank-PNC              •  bank-WellsF

  • bank-Ally                •  bank-Sofi

  • bank-Axos   

 

Cash

  • Cash

​

Exporting transaction files

  • Israeli Card spending transactions must only come from the card company website and not from the bank’s website where the card is paid.

 

   The logins to the Israeli card sites are:

  • card-Max 

https://www.max.co.il/cards  

        >> כניסה לאזור האישי

​

  • card-Isra   

https://digital.isracard.co.il/   

        >>  כניסה לחשבון שלי

​

  • card-Cal   

https://www.cal-online.co.il/  

        >>  כניסה לחשבון שלי

 

 

Navigating to the exportable Excel file page

  • For Israeli card transactions, follow the link(s) to

the פירוט חיובים option or

the עסקאות וחיובים option

​​

  • For Israeli bank transactions, look for

the תנועות בחשבון  page or

the עובר ושב (עו"ש) page or

the תנועות אחרונות page

​​

​​

Choosing the exportable Excel file

  • Israeli card transactions must be for no more than 1 billing-month per exported file. To do this follow the link לפי מועד חיוב

​​​

      For Isracard and Maxcard, the Tool will support an exported file containing a            single or multiple card-numbers' transactions. However, with cards issued from            CAL, due to the type of file content they use, the Tool will only support an                  exported file containing a single card number’s transactions within the same file.

​​

  • It is fine to have overlap of transaction date ranges that you export because duplicates are eliminated.

​​

  • Gaps between transaction date ranges that you export will result in missing transactions. Best to be aware of when you last exported the file by checking in the folder for the date it was created.

 

  • Choose the "אקסל" link to activate the download, or the document icon marked with an X     You might first have to click on the שמירה והדפסה link

​​

​

Placing the exported file into the designated folder

  • When you place your exported Excel files into their folders, if prompted whether to replace existing file, always keep both files.

 

​

Preparing the tool to operate on your device

  • When prompted in the reporting tool, you must:

​​

'Allow Macros’

​

and

​

‘Enable External Content’ (likely prompted at a separate interval of file-use)

 

Allowing Macros enables the automation in the file to run, thereby making it's updating extremely simple.

​

Enabling External Content allows for automized currency exchange tables sourced from the web.

​

The Tool:  Step 1 → File refresh

  • The first-time initiation refresh, depending on the number of transactions, can take 10  to 15 min. This lengthy refresh time should only be a one-time occurrence.

 

 

The Tool:  Step 2 → Categorization

  • The special undo / redo options found on this page act on changes made while using the unique Categorization Aid also found on that Excel page.  The normal undo / redo operates as well from its normal location in the standard Excel menu.

​​

  • When you populate your categorizations, in order to see in dropdown view the other entries on the other rows in the same column:

Select the cell in the categorization column that you want to edit, then press ALT + ↓,  then scroll the dropdown list using the up or down arrows (↓, ↑).

 

  •  Payments from your bank to your card account should be categorized as   “Transfer:Card Payment” or the like, making sure to at least use the word   “Transfer:” with a colon at the end.  Do the same with other internal transfers       between accounts in the Tool.

 

​​The reason is that these types of transfers are either not where the Tool captures the transaction (as is the case with card Payments, where the transaction is instead captured on the date of purchase), or are merely transfers from one bank account in the Tool to a different bank account in the Tool that do not represent a spending transaction.

​

Therefore, you should exclude these transfers from the Tool’s reports by “filtering out” the word "Transfer:" from the categories displayed on your reports.    

We will show you how this is done.

 

General

  • Make no edits to the contents of the exported transaction files 

  • Save the file before closing it.

​

​

Device Requirements

  • Windows 8.1 operating system or later.

  • MS Excel 2016 or later (Desktop version, not Online version).

 

​

 
bottom of page